macro object properties

  • Thread starter Thread starter Guillem Serra
  • Start date Start date
G

Guillem Serra

I wan to read the macro content. but I cannot find a Macro object. I find a
AccessObject but they have only the name property. How can I read the
Action, comment, etc?

Thanks In Advance

Guillem
 
I wan to read the macro content. but I cannot find a Macro object. I
find a AccessObject but they have only the name property. How can I
read the Action, comment, etc?
Click to expand...

Use DAO to look at the Containers and Documents collections and their
friends and relations. It's well documented in help.


Tim F
 
I have tried this recently and the container for macros is
called "scripts" in the containers collection.

The documents in the container collection however only
store the name of the stored macro but not the
individual 'macro actions'.

As an intermin measure highlight the macro in question in
the database window and then from the File Menu use the
save/Export item. This will give you the otion to convert
the macro into a VBA code meodule: effectively a series of
DOcmd actiuons.

Regards

Peter
 
Peter,

Yes, Thanks,
But I need to scan the contents of the macros.
Do you know if it is possible to automate the conversion by VBA?. In this
case I will be able to scan the created modules.

thanks again

Guillem
 
Back
Top