Export data with open sheet

[Guest]

Good things to alls.
I want to export an access 97 table to excel in this way:
after path request and "OK" by user, I would open Excel application (in
foreground) and show data processing.
Someone would help me?
many thanks in advance.
(I beg your pardon for my bad English)
Giangi

 

[John Nurick]

Hi Giangi,

You can use the VBA code here www.mvps.org/access/api/api0001.htm for
the "path request", and DoCmd.TransferSpreadsheet to export the table to
the Excel file.

Subsequently this VBA statement (where strFileSpec contains the path to
the Excel file) will open Excel with the file:
Application.FollowHyperlink strFileSpec

But I don't know what you mean when you say you want to "show data
processing".

 

[Guest]

Many thanks John.
At http://www.mvps.org/access/modules/mdl0035.htm there is three methods for
trasfer records to excel with Automation: I have tryed the first and it has
resolved my problem (thanks to Dev Ashish, also).
Good bye and good luck.

Giangi El Dotor
----------------------------------------------------------