How do you analyse macros in Access 97 using VBA? :-V
I have written a cross reference function in VBA that can find a nominated string and list the table, query, form, report or module it is found in. The function can also replace strings by opening one of the five objects above in design mode, making a change and saving the object.
However I cannot do any of the above for macros and it seems impossible to me. :-V
The best I can do is rename a macro’s name using DoCmd.Rename "Current Name", acMacro, "New Name".
The scripts collection does not allow the viewing of a macro’s parameters. Please help me. :-V
I have written a cross reference function in VBA that can find a nominated string and list the table, query, form, report or module it is found in. The function can also replace strings by opening one of the five objects above in design mode, making a change and saving the object.
However I cannot do any of the above for macros and it seems impossible to me. :-V
The best I can do is rename a macro’s name using DoCmd.Rename "Current Name", acMacro, "New Name".
The scripts collection does not allow the viewing of a macro’s parameters. Please help me. :-V