file dialog and export to excel

  • Thread starter Thread starter Raymond Chiu
  • Start date Start date
R

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
 
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
 
I have solved question 1 already.
It is using docmd.transferspeadsheet acexport, ...

Thanks,
Raaymond
 
Back
Top