List of a macro's commands in VBA?

[jasmith4]

When you open a macro in Design mode, you get the four columns, Macro Name, Condition, Action (with the parameter below) and Comment. Where is this list of actions in VBA? I've searched the database's Scripts container, the project's AllMacros collection, all properties for both -- nothing. EVen when I leave a macro open in design mode and examine all these with the VBE's Watch Window, nothing shows up.

The reason I ask is: I have a system to export all VBA code to text files, overwriting only the ones that change, so that I can do meaningful version control. So modules' lines of code and even a project's references are accessible via VBA -- but not macros' actions? Really?

 

[HiTechCoach]

That is my I avoid macros. No easy way to document or have any kind of versions control.

The only macros I might use are the special autoexec and autokeys macros. And that is only it I must.

 

[mdmilner]

Depends on what you're calling a macro.
When you use DoCmd, for example, you're actually running macros with it.

Something I read a long time ago:
http://www.fabalou.com/Access/AccessRants/trouble_with_access_2.asp


Historically, access has always had quirks where some functionality is sort of kludged together to make it work and sometimes requires unexpected tweaks to make things work. I remember adding this line, for example, to a process that ran into a record locking issue because it read through them too quickly.

DAO.DBEngine.SetOption dbMaxLocksPerFile, 30000

 

[jasmith4]

Macros. The regular UI macros you see in the database window when you click Macros under Objects in the left-side navigation pane. The things with the icons that look like little yellow paper scrolls. Not modules, macros.

For example, I always make a macro when I create any database called AutoExec, which Access always looks for and executes. It has two actions, RunCommand DocMaximize and RunCommand AppMaximize.

How in VBA can I examine that macro's list of actions?

 

[HiTechCoach]

Macros. The regular UI macros you see in the database window when you click Macros under Objects in the left-side navigation pane. The things with the icons that look like little yellow paper scrolls. Not modules, macros.

For example, I always make a macro when I create any database called AutoExec, which Access always looks for and executes. It has two actions, RunCommand DocMaximize and RunCommand AppMaximize.

How in VBA can I examine that macro's list of actions?

I just though of something ...

I found a old database that did have an AutoExec marco and ran this in the immediate window:

SaveAsText acMacro,"AutoExec", "C:\myapp\autoexec_macro.txt"

This exported the macro contents to a text file that you can read.

Does that help?

Boyd Trimmell aka HiTechcoach
Microsofft MVP - Access Expert

 

[HiTechCoach]

See:

Backing up and Restoring Objects

Boyd Trimmell aka HiTechcoach
Microsofft MVP - Access Expert