Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you get at a MacroObject's properties

Status
Not open for further replies.

rewdee

Programmer
Aug 17, 2001
295
US
I am trying to document a mdb file. I look at the Access Documenter and found it was not suitable to the task. I do need to document some features that the macros do have. One of them is a list of actions, arguments and values of a particular MacroObject but I do not know how to get them.

I can use this to get some properties as below but not others:

Dim doc As Document
Dim ctr As Container

Set ctr = currentdb.Containers("Scripts")
ctr.Documents.Refresh

For Each doc In ctr.Documents
If Not isDeleted(doc.Name) Then
LastDate=doc.LastUpdate
'something like Scripts(doc.Name).description
'but this does not work like if I had a report
'as in Reports(doc.name).visible=true
End If
Next doc

Any help would be greatly appreciated.

Thanks
Bill N
 
Thanks for the reply but unless I'm missing something I still do not have access to the descriptions, Actions, Arguments and value properties of the MacroObject.

Any suggestion?

Thanks,
Rewdee
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top