Using code to edit macros
 

I need to write a macro to change the code on several copies of a non-local
excel application. I do not know how to reference the code I need to change.
After creating the macro, it would be emailed to the users or the excel
programs. Is there a reference that would explain how.
Larry

Using code to edit macros
 

hi
see this site...
http://cpearson.com/excel/vbe.aspx
make note of the warning.

regards
FSt1

"Larry" wrote:

I need to write a macro to change the code on several copies of a non-local
excel application. I do not know how to reference the code I need to change.
After creating the macro, it would be emailed to the users or the excel
programs. Is there a reference that would explain how.
Larry

Using code to edit macros
 

Hi Larry,

Your question is not clear, but if you seek
a programmatiic means of editing or replacing
existing code, see Chip Pearson at:

Programming The VBA Editor
http://www.cpearson.com/excel/vbe.aspx


If, however, your intention is to distribute an
updated addin or to ditribute macros, see
Jan Karel Pieterse's tutorial at:

Creating An Add-in From An Excel Macro
http://www.jkp-ads.com/Articles/DistributeMacro00.htm

Which includes copious notte on the distribution
and installation of macros.



---
Regards.
Norman


"Larry" wrote in message
...
I need to write a macro to change the code on several copies of a
non-local
excel application. I do not know how to reference the code I need to
change.
After creating the macro, it would be emailed to the users or the excel
programs. Is there a reference that would explain how.
Larry