DoCmd.TransferSpreadsheet ( export data from a table in access to excel)

[mana]

hello

i have the following code and it runs without error but when i want to open excel file, i have the following message and i can't open it.
can you help me please?

i attached the error message


DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "tbl_userinformation", "G:\Rasteh Mona\Name.xlsx", True

thank you

 

[Minty]

Remove the xlsx extension from your file name. Also have you got excel 2007 installed on the machine that is saving the file?

 

[mana]

no it is excel 2010

 

[Minty]

okay try removing the acSpreadsheetTypeExcel12 text from your command.