export to excel with format

[iccsi]

I tried to export my report to excel spreadsheets.

I beleive that Access creates a new xls file on the destination.
Is it possible to export an existing spreadsheet and keep the
speadsheet format and multi spreasheets?

Your help is great appreciated,

 

[Arvin Meyer [MVP]]

This might be just the code you are looking for:

http://www.mvps.org/access/modules/mdl0035.htm