Iterate Macro Items (1 Viewer)

vbasean

New member
Local time
Yesterday, 18:27
Joined
Jul 22, 2008
Messages
3
I know I can iterate all the macros via 'AllMacros' object but can I iterate through the actual items in each Macro?
 

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 21:27
Joined
Feb 19, 2002
Messages
43,257
Yes, but I can't tell you how since I never use macros. Macros are stored in a container called Scripts and within that each macro is a Document. There should be another collection within Document that gets want you need.

I don't know why you need to do this but you may want to try the following:

Application.SaveAsText acMacro, D.Name, sExportLocation & "Macro_" & D.Name & ".txt"
 

vbasean

New member
Local time
Yesterday, 18:27
Joined
Jul 22, 2008
Messages
3
well, it's just the nature of what I'm working with and who has to administer it after I'm gone. It's just the way the system evolved. Sometimes you can't choose the methods, you just have to work with them.

VBA rules... but not everyone wants to decifer your code.
 

Users who are viewing this thread

Top Bottom