macro object properties

[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

 

[Tim Ferguson]

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?

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


Tim F

 

[Peter Davies]

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

 

[Guillem Serra]

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