TransferSpreadsheet macro action is not available.

D

DHAMM

I am trying to build a macro that performs the action "TransferSpreadsheet"
and exports data from a query to a spreadsheet. In the past and with Access
2003 I have been able to do this with no problem. I am currently using Access
2007. This command is not available in my macro command drop down list. I
searched in Access help files and believe that it is an issue with the Trust
Center settings. I have set my Trust Center settings to enable all macros and
I still cannot use the TransferSpreadsheet command. Any help would be greatly
appreciated.
Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top