Export to Excel

[Lynn_AccessUser]

I am exporting a query to excel using:

DoCmd.OutputTo acOutputQuery, "QueryName", acFormatXLS, , True

The issue is that one of the fields is a memo field and the data is being cutoff. There is no order by or group by on the query. I found one post that said to get around this issue use DoCmd.TransferSpreadsheet.

I tried this, but is there a way to allow the user to save the file anywhere with any file name like the DomCmd.OutputTo allows.

Here is my code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QueryName", filepath, True

Once again, I don't want to specify a filepath.

Thanks!!

 

[boblarson]

Check out this post on how you can use the file dialog to select your location and file name.

http://www.access-programmers.co.uk/forums/showpost.php?p=600859&postcount=5