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
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