file dialog and export to excel

[Raymond Chiu]

Dear all,

If I have the query which will be export to excel format and stored in a
file location which come from the file dialog, How can I do?
(1) export to excel format
(2) display windows file dialog to get the file location and file name.

Thanks for your big help

Raymond Chiu

 

[Raymond Chiu]

I have found the solution to the Question 2 in the MVPS web site.
But still waiting for export to excel command syntax?

ANy ideas?


Raymond

 

[Raymond Chiu]

I have solved question 1 already.
It is using docmd.transferspeadsheet acexport, ...

Thanks,
Raaymond