TransferSpreadsheet Craig 22.09.2006 19:27:01 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.

RE: TransferSpreadsheet Klatuu 22.09.2006 20:45:01 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 "Craig" wrote: [Quoted Text] > 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.

Re: TransferSpreadsheet John Nurick <j.mapSoN.nurick[ at ]dial.pipex.com> 22.09.2006 20:53:16 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. On Fri, 22 Sep 2006 12:27:01 -0700, Craig <Craig[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.