Run time error 3125 is not a valid name Make sure it does not include invalid characters and punctau

[jj1]

I am trying to export a query to excel using transferspreadsheet. But it's giving me an error Run time error 3125 is not a valid name Make sure it does not include invalid characters and punctuation. I don't understand I am getting this error.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, _
"Query9", "C:\Users\John\Desktop\Charts\Book1.xlsx", -1

[ranman256]

either acSpreadsheetTypeExcel12Xml (try another flag)
or query9 does not exist
or the path is invalid

[ssanfu]

From everything I read about the 'Run time error 3125", there might be some type of problem with the query.
http://stackoverflow.com/questions/5...el-from-access

Try deleting, then re-creating the query.

[jj1]

I tried to use another sample query and the code worked. So problem is in query. But I need to use the query. Why is giving me error in the query?

[ssanfu]

No idea, since all that you posted is the query name.