Using code to edit macros

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

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
 
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.
 
You must log in or register to reply here.

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

How to force macros refer to ActiveWorkbook 2
VBA set thick borders around non empty cells in range 0
How to split an excel workbook in code and data 2
Lose macros before saving 4
Programatically changing the macro content. 1
How to code macro to close Excel Application? 4
Excel Run macro upon cell edit 0
Word to Excel: Export comments with text and line number 0

Back
Top