Promp "Save As" Window For User

[crhodus]

Is there a way to launch a "Save As" window in Access that will allow the user to browse their computer and other network drives when saving a file?

I'm running the following code:

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryMailMerge1", acNormal, acReadOnly
DoCmd.SetWarnings True
'''' INSERT SAVE AS CODE HERE
DoCmd.TransferSpreadsheet acExport, 8, "tmpMailMerge", "C:\temp\testexport.xls", True, ""

I'd like to replace the "C:\temp\testexport.xls" part of the code with a string variable that will have the path and file name of where the user wants to save the file.

Thanks!

 

[Travis]

Check This site out

Save As Common Dialog

 

[crhodus]

Thanks Travis! I ended up using code from the following page that I found:
http://www.mvps.org/access/api/api0002.htm

After I captured the path from this module, I created a form with a textbox that the user can enter in a file name, then appended it to the value I received from the function.

Thanks for your help!