I am trying to build a MS Access 2007 macro that performs the action "TransferSpreadsheet" and exports data from a query to a spreadsheet. The command is hidden i.e. not showing in macro command drop down action list in Access 2007. I have set my Trust Center settings to enable all macros but still, I cannot see the TransferSpreadsheet command. Any idea?
Note: this command was easily found with MS Access 2003.
Thanks in advance
Note: this command was easily found with MS Access 2003.
Thanks in advance