How to export Query data to Excel with save as dialogue box to save in directory

[arunhalyal]

Hi,
I could export query values to excel through below mentioned code

DoCmd.OutputTo acOutputQuery, "Qry_setter", acFormatXLS, "C:\Temp\Setter.xls", , , True

But I require a dialogue Box to chose path where I can save file in local directory.
Please help me on this regard

Thanks in advance.

[ItsMe]

You can use some file picker code to store the path in a string. Instead of "File" you use "Folder" in part of the code to call the Windows Dialogue.

The example DB in this post uses both file and folder. I believe it is "folder" for the path only. The first form that launches in the DB is to go after a file and the second form is the one with an example for folder paths.
https://www.accessforums.net/access/...tml#post207920

[lfpm062010]

This should help you to select a file or directory.

http://msdn.microsoft.com/en-us/libr.../ff835934.aspx

Then use the return variable to replace with you DoCmd.


DoCmd.OutputTo acOutputQuery, "Qry_setter", acFormatXLS, RETURN_VALUE, , , True

[arunhalyal]

Thanks for reply.

I need a file to be saved with report number, for example "Furnace121.xls".

If I give folder name it throughs error and if I pass only file name value it will get saved in My Documents.

Regads
Arun

[arunhalyal]

Thanks for reply.

I should directly save file in directory. I need not select folder.

Regards
Arun

[June7]

Can use the file dialog to pick folder path then concatenate it with whatever filename you want.