Convert Macro to VB

[DBFIN]

I have a macro with at least 50 action lines that I selected from the action catalog. I need to edit all 50 lines for a variety of reasons. If I convert the macro to visual basic, is there a simple way to edit the 50 lines with and "Edit / Replace" option and then convert the visual basic back to the original format before it was converted to visual basic.

Your help is always greatly appreciated !!

 

[Beetle]

There is no way to convert back to a Macro from VBA. It sounds like you're talking about a newer version of Access (i.e. A2010), in which case you could copy your macro into Notepad, which will give you the XML version of your macro. It won't be easy to read, but you could use Edit/Replace from there if you wanted, then copy the modified XML back to a macro window. You would need to give it a different name until you can test/verify the functionality. Then you could delete your old macro and rename the new one. If you want to do this, make a backup first, and do so at your own risk.