TransferSpreadsheet

[Guest]

Hello,
I have queries that I'd like the user to be able to export to Excel. I set
them up with DoCmd.OutputTo and this works as desired, except for the fact
that it limits the number of rows (saved as older version). I understand the
solution is to use TransferSpreadsheet, but would like to retain the ability
for the user to select the directory where the file is saved to & change
filename if so desired, as the OutputTo function does.

 

[Guest]

This will require some VBA coding to allow the user to navigate to the file
name as they do now. You can use this API code from this site to present to
Open/Save dialog

http://www.mvps.org/access/api/api0001.htm

 

[John Nurick]

Hi Craig,

You can use the code at http://www.mvps.org/access/api/api0002.htm to
let the user select a folder, or
http://www.mvps.org/access/api/api0001.htm to specify both location and
filename. Then pass the filespec to TransferSpreadsheet for the actual
export.