TransferSpreadsheet

[roberemok]

Can anybody help me with this action? I'm trying to export a query to Excel and I'm wondering if this would do this.

 

[Hayley Baxter]

Option 1: Use the following code

Sub export_to_excel()
Dim mfile
myfile = "Your path name/spreadsheet name.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "your query name", myfile
End Sub()()

Option 2

Use the Transferspreadsheet action in a macro - Although I think this option only allows you to export from a table not a query. I always use option 1.

HTH
Hay

 

[lushh]

Option 1: Use the following code

Sub export_to_excel()
Dim mfile
myfile = "Your path name/spreadsheet name.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "your query name", myfile
End Sub()()

hi. sorry, i am just a newbie here. where should the code be placed? because i am currently experiencing the same problem. thanks.