By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,808 Members | 1,481 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,808 IT Pros & Developers. It's quick & easy.

Programmatically documenting macros

Expert 100+
P: 112
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.
Mar 18 '08 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,636
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.
Expand|Select|Wrap|Line Numbers
  1. Dim MyDB As DAO.Database
  2.  
  3. Set MyDB = CurrentDb()
  4.  
  5. With MyDB.Containers("Scripts").Documents("AutoExec")
  6.   Debug.Print "Container: " & .Container
  7.   Debug.Print "Date Created: " & .DateCreated
  8.   Debug.Print "Last Updated: " & .LastUpdated
  9.   Debug.Print "Name: " & .Name
  10.   Debug.Print "Owner: " & .Owner
  11.   Debug.Print "User Name: " & .UserName
  12.   Debug.Print "Permissions: " & .Permissions
  13.   Debug.Print "All Permissions: " & .AllPermissions
  14. End With
OUTPUT:
Expand|Select|Wrap|Line Numbers
  1. Container: Scripts
  2. Date Created: 4/13/2007 6:45:18 PM
  3. Last Updated: 4/13/2007 6:45:18 PM
  4. Name: AutoExec
  5. Owner: admin
  6. User Name: admin
  7. Permissions: 1048575
  8. All Permissions: 1048575
Mar 19 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.