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

Here is a start

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

--
Regards,
Tom Ogilvy


"Brett Smith" <(E-Mail Removed)> wrote in message
newsB7DD16E-C467-4556-B0EB-(E-Mail Removed)...
> 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

Thanks Tom. This should be a good start. Thanks once again. I will use
this and apply a change text sub as opposed to the delete or add text sub
when writing a VBA macro. But how do you search all subdirectories within a
given directory and be able to change modules from there?

Brett

"Tom Ogilvy" wrote:

> Here is a start
>
> http://www.cpearson.com/excel/vbe.htm
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Brett Smith" <(E-Mail Removed)> wrote in message
> newsB7DD16E-C467-4556-B0EB-(E-Mail Removed)...
> > 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
>
>
>