transfer spreadsheets

[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......

 

[Guest]

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

Randall Arnold

 

[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