Export and Save to user selected path

[Guest]

Hello:

I would like to export my query to Excel format. I know how to write export
specification. I don't know how to bring SAVE dialog in my VBA code so user
can select the path. I would like not to hardcode the code.

Can you assist?

 

[John Nurick]

There's code here http://www.mvps.org/access/api/api0001.htm for using
the standard File Save dialog.

 

[Guest]

Hi Hohn:

Thanks for directing my to the source information. This will work for me.