I am getting error 3011 when trying to export a table or query (any table or query - I've tried just about every one): "Cannot find the object", despite the fact that the object is spelled correctly and exists. This is happening for local tables/queries as well as passthrough queries and linked tables.
The code is fairly simple (although I get the same error message when I try to use the export wizard, so I'm sure the code isn't the problem
Code:
DoCmd.TransferSpreadsheet acExport, , "CVDataQ", CurrentProject.Path & "\reports\templates\CurrentVendorTotalsbyYearQ.xlsx"