Imbeded Macro to Export To Excel Problem

W

Wally

I have a database that has a form that allows me to select a date range then
export the data to Excel. This worked fine until I upgraded to Office 2007.
Now it appears that Access 2007 doesn't support the .xls format and
appearantly wants me to re-write the macro to .xlsx format. However, I
cannot figure out how to edit the macro in the form. I see the code
referencing the macro but cannot figure out how to edit the actual macro. I
do not see this macro in the "create macro" window either.

Alternatively, the error message says I could somehow install the ability
for Access to export to .xls format but don't see how to do that either.

Thanks for your help.

Wally
 

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