Programmatically documenting macros

[janders468]

Hi All,
I am looking for a way to programmatically pull information about macros from the database. For instance, I would like to be able to pull the names of the arguments out and put those in a table. I know of SaveAsText and I can pick the text files apart based on their structure but it seems a clumsy way to do it. Are any of the macro properties exposed in the access object model?

Thanks in advance.

[ADezii]

Hi All,
I am looking for a way to programmatically pull information about macros from the database. For instance, I would like to be able to pull the names of the arguments out and put those in a table. I know of SaveAsText and I can pick the text files apart based on their structure but it seems a clumsy way to do it. Are any of the macro properties exposed in the access object model?

Thanks in advance.

These are some of the Properties I know you can retrieve, but as far as the rest, I'm not really sure if they are retrievable.

Dim MyDB As DAO.Database
 
Set MyDB = CurrentDb()
 
With MyDB.Containers("Scripts").Documents("AutoExec")
  Debug.Print "Container: " & .Container
  Debug.Print "Date Created: " & .DateCreated
  Debug.Print "Last Updated: " & .LastUpdated
  Debug.Print "Name: " & .Name
  Debug.Print "Owner: " & .Owner
  Debug.Print "User Name: " & .UserName
  Debug.Print "Permissions: " & .Permissions
  Debug.Print "All Permissions: " & .AllPermissions
End With

OUTPUT:

Container: Scripts
Date Created: 4/13/2007 6:45:18 PM
Last Updated: 4/13/2007 6:45:18 PM
Name: AutoExec
Owner: admin
User Name: admin
Permissions: 1048575
All Permissions: 1048575