Macro at run time

Joined
Oct 4, 2005
Messages
1
Reaction score
0
Hello everyone!

What I am trying to do is read the action arguments of the already existing macros in the database to determine if macro is dependent on any underlying query or tables.

As I couldnt find any way to do it my changed plan was to convert the macro to vba at the run time and then look through the codes generated to determine the dependency. I couldnt find a way to do this as well the closest i cold think of was :


For Each c In CommandBars("Menu Bar").Controls("&Tools").Controls("Macro").Controls

If c.Caption = "Convert Macros to Visual &Basic" Then
c.Execute ' this step fails i couldnt find any documentation on wher this supports automation!
End If

Next c

will appreciate any help regarding this matter
many thanks in advance
 
Back
Top