How to Update a macro's properties thru VBA code?

  • Thread starter Thread starter witharebelyell
  • Start date Start date
W

witharebelyell

Hi is it possible to update the properties of a macro step? Eg if i
have a TransferText
command in a macro with a property Table Name how do I update thru
code? I have many macros and i don't want to manually configure them
all. It this possible..?

eg. this is how har i've gone ...using DAO

CurrentDb().Containers("Scripts").Documents(0).Properties("??????").????
how do i get to the macro steps property step? ..for a guru??

mike
 
AFAIK, you can't get at these in VBA.

You can export Macro1 as a file, using the undocumented SaveAsText
SaveAsText acMacro, "Macro1", "C:\macro1.txt"
And you can create a macro with the matching LoadFromText:
LoadFromText acMacro, "Macro1", "C:\macro1.txt"

I can't recall trying to edit a macro in the file between those operations.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA to update cross-referencing 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Build VBA instead of MACRO 1
Word to Excel: Export comments with text and line number 0
Dealing with a macro through DAO 3
Finding properties of a macro in code 2
Finding the values of an Object's Properties 2
MS Access Macro error on TransferText 1

Back
Top