Need help programatically building macros

[Rob Diamant]

Is there a way using VBA to build Macros? If so, can someone point me in the
right direction.

Thanks
Rob

 

[John Vinson]

Is there a way using VBA to build Macros? If so, can someone point me in the
right direction.

Thanks
Rob

Why on Earth would you want to do so?

VBA can do *everything* which Macros can do, more readably and more
flexibly (and with error trapping as well).

Could you explain why you feel that you need to do this, and what you
are trying to accomplish?

John W. Vinson[MVP]

 

[Rob Diamant]

John,

I have have 100+ access databases and I am trying to provide them some
common functionality. I have already created an Addin to handle some of my
mischief. One thing I still want to do is sync my AutoKeys macros. Over time
I keep adding new functions and I would like an easy way to create/update
each database's copy of the macro without manually having to create it. In
the same context, I also would like to be able to add / replace common VB
modules. Unless you know of a way to reference the macros or vb code from an
Addin.

Thanks

Rob

 

[Douglas J. Steele]

I don't believe there's any way to programmatically program macros, but you
can use the undocumented SaveAsText/LoadFromText methods. Use SaveAsText to
see what should be in the text file. You can use VBA code to create an
identical file and use LoadFromText to get it into the database.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)