I have a crosstab query which i want to export, using a Macro, as an excel sheet to a specific folder (using TransferSpreadsheet or TransferText options in the Macro). Any ideas on how i fill in the required fields? keep getting the error "Cannot update: database or object is READ ONLY".
I have it working perfectly for Make table queries (using TransferSpreadsheet)and it emails me the link when the macro completes. I just want to add this crosstab query to the Macro so that it also exports.
Any help would be greatly appreciated!
I don't use macros - don't understand them and find they are a nightmare to debug (or whatever you call fixing a macro).
Check out this thread - it is an alternative means of getting the data into Excel. On the second page is a template you can adapt and use. I know it works for Crosstabs because this was Blindman's requirement and I tested it before posting.