M Mehmet Ceylan Feb 11, 2004 #1 How can I export the data to an excel file from a listbox on the form?
N Naresh Nichani MVP Feb 12, 2004 #2 Hi: If the data in List is from a table on based on a SQL statment use thhsi VBA code on a button to do the excel export. application.DoCmd.TransferSpreadsheet acExport,acSpreadsheetTypeExcel3,"TableName","C:\My DOcuments\Test.xls" Here TableName is the name of Table to export and is exported to Test.xls. Regards, Naresh Nichani Microsoft Access MVP
Hi: If the data in List is from a table on based on a SQL statment use thhsi VBA code on a button to do the excel export. application.DoCmd.TransferSpreadsheet acExport,acSpreadsheetTypeExcel3,"TableName","C:\My DOcuments\Test.xls" Here TableName is the name of Table to export and is exported to Test.xls. Regards, Naresh Nichani Microsoft Access MVP
J Joseph Meehan Feb 12, 2004 #3 Mehmet said: How can I export the data to an excel file from a listbox on the form? Click to expand... If you want to start Excel at the same time, you could use "send keys" to trigger the tools, office links, publish with Excel menu commands.
Mehmet said: How can I export the data to an excel file from a listbox on the form? Click to expand... If you want to start Excel at the same time, you could use "send keys" to trigger the tools, office links, publish with Excel menu commands.
