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
----------------------------------------------------------
"John Nurick" wrote:
[Quoted Text] > 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".
>
> On Fri, 14 Jul 2006 06:48:02 -0700, Giangi
> <Giangi[ at ]discussions.microsoft.com> wrote:
>
> >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 [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.
>
|