Export table to Excel (option to choose the root)

[charly.csh]

Hi everyone,



I am trying to make an exportation to Excel and it's showing an error:

'************************
Private Sub Excelcmd_Click()
'Access 365

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Test", "C:\Users\XXXX\Desktop\Book1.xlsx", True

'************************

(error 3011: the microsoft office access database engine could not find the object)
it's weird because when I see into the folder on the root the file is there, once I want to open it, it shows is damaged

Any idea how to correct this?
And second question, does somebody know how to get alternative to choose the root instead of getting predefinded? ( "C:\Users\XXXX\Book1.xlsx")

Thanks in advance for the help!!!!

[June7]

Why are you using Excel9? Try Excel12Xml

If you want user to select a folder location, use FileSystemObject dialog. Common topic.

[charly.csh]

In fact I tried it as well and same error message is shown (error 3011)

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Test", "C:\Users\XXXX\Book1.xlsx", True

The only difference is that at least it can be opened but no info...

Any idea why? or how to correct this?

[June7]

No idea. Since a file is created, can't be a folder permissions issue.

[Minty]

What result does just opening the query "Test" give you?
Does it run?