How to open existing Excel file & paste Access data...

[Guest]

I am wondering what kind of code I need to use to open an existing Excel file
& paste Access data into an existing tab - with the key being to preserve the
formatting on the worksheet tab that already exists - such as font, column
width, page headers, conditional formating and formulas.

Currently, my code runs a sql query to find all records for each service
technician and emails them their work queue for the day to their
PDA/Blackberry using TransferSpreadSheet since SendObject formats in an old
Excel version. The TransferSpreadsheet appears to overwrite the entire tab
if the tab has the same name as the query. Erases the formatting I put in
place and pastes it in a generic way.

Any insight is much appreciated!!
Thanks!!

 

[pietlinden]

I am wondering what kind of code I need to use to open an existing Excel file
& paste Access data into an existing tab - with the key being to preserve the
formatting on the worksheet tab that already exists - such as font, column
width, page headers, conditional formating and formulas.

Currently, my code runs a sql query to find all records for each service
technician and emails them their work queue for the day to their
PDA/Blackberry using TransferSpreadSheet since SendObject formats in an old
Excel version. The TransferSpreadsheet appears to overwrite the entire tab
if the tab has the same name as the query. Erases the formatting I put in
place and pastes it in a generic way.

Any insight is much appreciated!!
Thanks!!

use CopyFromRecordset? See Access Web... www.mvps.org/access - should
be in the Modules section