By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,298 Members | 662 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,298 IT Pros & Developers. It's quick & easy.

How to export an Access 2007 report to Excel via VBA

100+
P: 137
I know there's a few topics on the forums about this already, but none of them seem to have a definitive answer, and it's unclear if they're for 2003 or 2007.

I've got a report in Access 2007 that I would like to be able to export to Excel using VBA.
The ribbon already has an option to export to Excel, which does everything I want, but the ribbon gets disabled as one of my security protocols, so the users are blocked from using the export options here.

Is there a way to call this feature from VBA/Allow this on a custom built ribbon/do something similar via VBA?

I've looked into using the TransferSpreadsheet method, but the query for my report is a rather big union query, based on a filter form, and is too complex for the TransferSpreadsheet method to use.

Any help would be appreciated.

Thanks.

Adam.
Jul 20 '11 #1
Share this Question
Share on Google+
1 Reply

100+
P: 137
Ah sorry you can probably ignore this one, I've found that I can add them as buttons on the quick access bar, which will suffice for now.
Jul 20 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.