How to edit VB code programmatically

[Jon]

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!

 

[Bob Phillips]

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

--

HTH

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