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

mana

Registered User.
Local time
Yesterday, 19:41
Joined
Nov 4, 2014
Messages
265
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
 

Attachments

  • Unbenannt.jpg
    Unbenannt.jpg
    78.8 KB · Views: 159
Remove the xlsx extension from your file name. Also have you got excel 2007 installed on the machine that is saving the file?
 
no it is excel 2010
 
okay try removing the acSpreadsheetTypeExcel12 text from your command.
 

Users who are viewing this thread

Back
Top Bottom