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
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