Imbedded Maco Problem

[pspr]

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 export .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 code. 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 I don't see how to do that either.

Thanks for your help.

Wally

 

[Ziggy1]

do you know for sure it is a Mavro versus VBA (coding), in Access a Macro is a series of Actions you select, and then the VBA is actual coding to do the same..an Access macro is not the same as an Excel macro.

You need to go into the design of the form then open the property of the button that triggers the export, look in the On click section and note the name...you can click on the builder button "..." to open the macro in design

One thing with Access 2007 is some macro actions are disabled by security seetings.....I don't have time to explain that...try a search for Access 2007 security.