SaveAs Dialog Box Access 2000

[bzimmer]

I am trying to export an access report to excel. I can currently export the data and save it by hard coding the file location. I want to prompt the user for the location where they want to store it. I am not sure how to do this in Access 2000. From what I do understand is the built in FileDialog do not work in 2000?

Thanks,

[bzimmer]

This is what I have to save the report to the hard code location. I want to prompt for the location though.

Private Sub btnExport_Click()
DoCmd.OutputTo acOutputReport, "Report Hourly", acFormatXLS, "C:\Dropbox\Report Hourly.xls"

End Sub

[ruirib]

See if this can be of help: http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

[bzimmer]

I tried that and the code from Listing C where it makes declarations does not compile.

[ruirib]

See if this one works: http://www.ammara.com/access_image_f...en_dialog.html. You can download the code.

[tgw7078]

Try this:

API: Call the standard Windows File Open/Save dialog box
http://access.mvps.org/access/api/api0001.htm

[bzimmer]

If you use the following command:

DoCmd.OutputTo acOutputReport, "Report Hourly", acFormatXLS, "C:\Dropbox\Report Hourly.xls"

And leave off the location it will automatically prompt you for a location.