Need help with Macro container

[Lperkin]

Hi, I was wondering if anybody could help me.

I have an application that iterates through each querydef, report, tabledef and form producing a table of all database objects which is useful to document database architecture. However, I cannot find a way to access the Macro Container via vba. It would be really useful if I could iterate through each macro, detailing each action and its parameters.

If anybody has any help on this, or can at least explain to me how Macros are actually stored within the Access DBE, that would be really helpful.

Many thanks in advance.

 

[Lperkin]

So I am guessing I have stumped you all then?

 

[vbaInet]

Nope. No way to iterate through Macros. You would have noticed that there isn't a Macros collection as there is a Forms or a Reports collection. You can convert a macro to vba and document based on that instead. It wouldn't be a quick job!

Welcome to AWF by the way

 

[Lperkin]

LOL, thanks, I knew this, but my boss was adamant that it could be done. I now feel vindicated.

 

[vbaInet]

I think you should get your boss to prove it to you, then tell him you will do the rest from his example

 

[Lperkin]

LOL, he said he had a solution, and then over a weekend his "strategy" for the problem suddenly changed.

 

[vbaInet]

Boss' always have "great" ideas lol