VBA, OutputTo and Destination path

OutputTo and Destination path

Author	Message
Enrico Benell #1 / 3	OutputTo and Destination path I have the following problem. I have a series of queries that I run each month and I want to Output ther results of the queries into different folders each month (ie October98; November98 etc...). I created a dialog form in which I select the parameters (month and year) for the queries. How do I now tell Access that it has to store the output Excel files into the correct folder for that month? I have tried to play around with the expression below but couldnt find the correct way to do it. Does anybody can help?? Thanks enrico DoCmd.OutputTo acOutputQuery, "Queryname", acFormatXLS, "c:\october98\filename.xls"
Tue, 31 Jul 2001 03:00:00 GMT

Manish Jh #2 / 3	OutputTo and Destination path Use DoCmd.TransferSpreadsheet instead of OutputTo Also you may want to look at the add-in below... -- ********************************************** Manish Jha Data Flow Manager Data Migration add-in for MS Access http://pages.prodigy.net/manishj/psdfm.htm ********************************************** Quote: > I have the following problem. > I have a series of queries that I run each month and I want to Output > ther results of the queries into different folders each month (ie > October98; November98 etc...). > I created a dialog form in which I select the parameters (month and > year) for the queries. How do I now tell Access that it has to store the > output Excel files into the correct folder for that month? > I have tried to play around with the expression below but couldnt find > the correct way to do it. > Does anybody can help?? > Thanks > enrico > DoCmd.OutputTo acOutputQuery, "Queryname", acFormatXLS, > "c:\october98\filename.xls"
Tue, 31 Jul 2001 03:00:00 GMT

David Fournie #3 / 3	OutputTo and Destination path Have you tried something like this: dim strFolderName as String strFolderName = me.txtFolderName DoCmd.OutputTo acOutPutQuery, "Queryname",acFormatXLS, _ "c:\" & strFolderName & "\filename.xls" Where me.txtFolderName is a Text box on your form. Quote: >I created a dialog form in which I select the parameters (month and >year) for the queries. How do I now tell Access that it has to store the >output Excel files into the correct folder for that month? >I have tried to play around with the expression below but couldnt find >the correct way to do it. >DoCmd.OutputTo acOutputQuery, "Queryname", acFormatXLS, >"c:\october98\filename.xls"
Fri, 03 Aug 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]