Programmatically documenting macros

[janders468]

Hi All,
I am looking for a way to programmaticall y 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 programmaticall y 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.
[CODE=vb]
Dim MyDB As DAO.Database

Set MyDB = CurrentDb()

With MyDB.Containers ("Scripts").Doc uments("AutoExe c")
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 "Permission s: " & .Permissions
Debug.Print "All Permissions: " & .AllPermissions
End With[/CODE]
OUTPUT:
[CODE=text]
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[/CODE]