How to Dump all Macro to the log

[joe12]

I used the Run Script step from the above "LogMacros.bld" example.
It worked for a while, but now out of the blue, I get an error on that VBScript code. The error reads:

Error in Run Script (VBScript) script code at Line 15, Column 4 (Type mismatch: 'Application.ExpandMacrosAndScript')
6/6/2011 5:37:12 PM: Step '14 - Dump All Macro Information to Log' failed
6/6/2011 5:37:12 PM: Build ended (elapsed = 00:00:00).



In the log , it stopped right after writing the lines:

=============================================
****** temporary macros ******


So I examined my Temporary macros, and sure enough I found what is causing the failure. I have an ADO_RS macro sitting around in the temp macros (from an earlier call to SQL with a Loop Action Step to parse that SQL just after).

If I delete that ADO_RS macro, then the "Dump All Macros" step goes back to working.

Is there a way to make this VBScript more robust so that it will dump all the macros even when the macros collections contain one or more macros that are some type of list or whatever?

[kinook]

Here is an updated project which handles that.