- Local time
- Today, 01:02
- Joined
- Feb 28, 2001
- Messages
- 30,474
Because of some unusual documentation requirements (U.S. Dept. of Navy), I have built a cross-referencer that works by opening the various collections of my database. It steps through the contents thereof, examining each in turn (in design mode). I make entries in a separate table, then run a report off the result. It sounds bizarre but it is incredibly useful if you have lots of forms, reports, tables, or queries to maintain - and I do. For instance, a simple query finds every place where I referenced item XYZ - and finding the reference is of course the first step in any maintenance operation.
My problem is that I cannot see the contents of a macro from my VBA code. There is a DoCmd.OpenForm, a .OpenReport, a .OpenQuery, etc., all of them allowing a "design mode" operation - but no .OpenMacro (at least not that I could find in Access 97).
I suppose I could manually export the macros as VBA code - but who wants to do ANYTHING manually? Besides, in line with the idea of automating things, I really don't want to have do to that many exports by hand every time I update any macro.
Does anyone have any ideas about how to open a macro (script) from VBA in a way that lets me see the contents without actually running the macro? I'll even consider "backdoor" methods if required.
My problem is that I cannot see the contents of a macro from my VBA code. There is a DoCmd.OpenForm, a .OpenReport, a .OpenQuery, etc., all of them allowing a "design mode" operation - but no .OpenMacro (at least not that I could find in Access 97).
I suppose I could manually export the macros as VBA code - but who wants to do ANYTHING manually? Besides, in line with the idea of automating things, I really don't want to have do to that many exports by hand every time I update any macro.
Does anyone have any ideas about how to open a macro (script) from VBA in a way that lets me see the contents without actually running the macro? I'll even consider "backdoor" methods if required.