CODEWITHSUNDEEP
ms-accessvba
mshahrim
mshahrim

Reputation: 53

MS Access : Can we edit the Macro in VBA? and how?

The Scenario: So I have a form called FormA, and that form has a button called buttonA. When I click buttonA it runs a Macro that will open a form, FormB.

The Question: Can I edit the Macro in VBA? Making it open FormC instead.

Upvotes: 0

Views: 1156

Answers (1)

jhTuppeny
jhTuppeny

Reputation: 970

You can export the code from a macro using;

Application.SaveAsText acMacro, <MacroName>, <Filename>

and then you can import code back after editing using;

Application.LoadFromText acMacro, <MacroName>, <Filename>

The text content of the macro isn't VBA but you could probably edit it successfully.

Upvotes: 2

Related Questions