Controlling Excel from Access

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I have a requirement to table a query from Acess and automatically open an
existing excel spreadsheet, create a new sheet and export the data.
I understand how to export the data but I am having problems opening a
specific sheet.
The help files are a little short on detail.
Can anyone help?

Office 97

Thanks

Andy
 
Andy,

Take a look at a thread titled "How do I specify a worksheet within the
excel file path?", original post by "MrPC" on Noc.23, in NG
microsoft.public.access.macros. Although it refers to a macro there, the
exact same things hold true in code, using the TransferSpreadsheet method.
Just not 100% sure it works in A97 (I have A2K), but worth a shot.

HTH,
Nikos
 
Back
Top