Export to Excel Code problem

[GirlBlonde]

hi i am trying unsuccessfully to export a query automatically via a button to excel using the below code but i keep getting errors. can anyone see where i am going wrong? very frustrated.

thanks


query is called exportexcel spreadsheet is SendCarRequestExcel and the sheet name is also SendCarRequestExcel


DoCmd.TransferSpreadsheet acExport, "MicrosoftExcel(*.xlsx)", "[[Exportexcel]]", "[[SendCarRequestExcel]]", False, "[[SendCarRequestExcel]]"


Energy & persistance conquer all things!

 

[PHV]

Why all those [[ and ]] ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[GirlBlonde]

hi i got it from the internet. i can not find it in the file above via search???am i looking in the wrong space?

Energy & persistance conquer all things!

 

[PHV]

Put the cursor inside the TransferSpreadsheet word in your code and press the F1 key.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886