B
BAC
Office 2000 Pro, Win 2000 Pro
Using Access to download from our datawarehouses and outputting the results
to Excel has become very popular in our office. I have several apps that do
this. However, if I'm running one of these apps, I cannot open Excel, or
view the output "as it's happening" or the running program will output it's
results to the visible Excel Workbook/sheet and not to the actiev workbook
within the instance of Excel it's supposed to be working with...
How do I force Access to ALWAYS write to the appropriate instance of Excel
regardless of whatevere eles I might be doing with other Excel spreadsheets??
Thanx..
BAC
Using Access to download from our datawarehouses and outputting the results
to Excel has become very popular in our office. I have several apps that do
this. However, if I'm running one of these apps, I cannot open Excel, or
view the output "as it's happening" or the running program will output it's
results to the visible Excel Workbook/sheet and not to the actiev workbook
within the instance of Excel it's supposed to be working with...
How do I force Access to ALWAYS write to the appropriate instance of Excel
regardless of whatevere eles I might be doing with other Excel spreadsheets??
Thanx..
BAC