Here is a start

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy


"Brett Smith" wrote in message
...
I am looking to write an automated program in VBA where it will search and
replace several variables with updated names. I also need to update
different template or VBA projects in order to do this because there are
many
Excel projects that also need to be updated in the same directory. How
would
I code this to automatically open up Excel worksheets, replace variables
in
the VBA macro code in order to update it, and then close it when done.
Then
it would open up the next Excel worksheet. Anybody have an idea?

Brett