Export Automation (Marcro) ???

[RookieDBO]

When using the "Transfer Spreadsheet" macro in Access 97, is it possible to format the spreadsheet as well?
For example, set up the print format and bold the column headings, etc... I'm trying to avoid having to do it daily in Excel 97.

Thanks,
RookieDBO

 

[Databaseguy]

The only way is to open an instance of Excel and manipulate the OLE server and Excel Objects directly.

The code to do it can get rather lenghty.

Go to the MS Knowledge base and search for Automation. There's some good examples there.
Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[RookieDBO]

Thanks. Where is MS Knowledge Base?

RookieDBO