Controlling Excel from Access

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
 
N

Nikos Yannacopoulos

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Open to Specific Excel Tab 1
Exporting Data From Excel to SQL 1
Access 2000 to Excel 1
import excel using script 2
Exporting to Excel (Macro) 1
export to excel from access 2
Transfer data directly to Excel spreadsheet 3

Top