How to edit VB code programmatically
 

All,
I have a large set of excel files with which I need to add a VB module
then Find and Replace existing VB code with new VB code. Is there a way to
do this programmatically? In other words I don't want to manually open every
Excel file, add the module, and then run the Find and Replace. Instead Id
like to build a program/script to handle it all. Any help would be
appreciated. Thanks in advance!

--
J

How to edit VB code programmatically
 

Take a look at www.cpearson.com/excel/vbe.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jon" wrote in message
...
All,
I have a large set of excel files with which I need to add a VB module
then Find and Replace existing VB code with new VB code. Is there a way
to
do this programmatically? In other words I don't want to manually open
every
Excel file, add the module, and then run the Find and Replace. Instead I'
d
like to build a program/script to handle it all. Any help would be
appreciated. Thanks in advance!

--
J