Run time error '3011' exporting to excel

[garethdavies]

I'm attempting to export some table queries to excel using the code I have posted below as a module.

I am getting an error saying it cannot find my query.

I have used this code to do the above on 2 queries within the same table and it works fine. I don't understand why it would not work for a different query.

Any help would be greatly appreciated.

Option Compare Database
Private Sub exportQueryToExcel()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "CUSTOMER FOCUS", "C:\Users\gareth.davies1\Desktop\Training\SHAREPOINT FEED MASTER.XLSM", True
End Sub

 

[marlan]

Hi,
Are you sure there is no typo in the query name: "CUSTOMER FOCUS"?

 

[Solo712]

SHAREPOI NT ...

...............Really ?

 

[LOUISBUHAGIAR54]

check whether there is an empty space in SHAREPOI_NT.

 

[vbaInet]

...also what is the full error message?

Welcome to the forum as well garethdavies