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

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
 
A

Allen Browne

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.
 
Top