transfer spreadsheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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......
 
It's possible, but you may want to actually use the Excel object instead so
that you can specifiy the individual worksheets.

Randall Arnold
 
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
 
Back
Top