How to Update a macro's properties thru VBA code? witharebelyell[ at ]hotmail.com 15.08.2006 00:10:07 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

Re: How to Update a macro's properties thru VBA code? "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 15.08.2006 04:15:05 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. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. <witharebelyell[ at ]hotmail.com> wrote in message news:1155600607.660517.134800[ at ]74g2000cwt.googlegroups.com... [Quoted Text] > 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??