transfer spreadsheets

J

JT

I have used the transfer spreadsheet command it works just fine. However, I
would like to kick off 2 queries, 0ne after the other, and have the results
write to different sheets in the same workbook. Is this possible? Thanks
for the help......
 
R

Randall Arnold

It's possible, but you may want to actually use the Excel object instead so
that you can specifiy the individual worksheets.

Randall Arnold
 
D

Dave Patrick

Create a macro that uses TransferSpreadsheet command on two separate lines
then specify the same workbook for 'File Name' and the two different query
names as 'Table Name'

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I have used the transfer spreadsheet command it works just fine. However,
I
| would like to kick off 2 queries, 0ne after the other, and have the
results
| write to different sheets in the same workbook. Is this possible? Thanks
| for the help......
| --
| JT
 
Top