Hi,

I have about a 100 workbooks all with the same VBA code in them. I
need to change a line in the VBA code in each of them and would like
to use code rather than opening each of the workbooks and changing it.

Can this be done? I just need the code to reference the line and make
the change - I have the code to open each workbook and close it
already in a directory.

Thanks,
Derrick

You can see how to program the VBE/modify code with code by looking at Chip
Pearson's site

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

--
Regards,
Tom Ogilvy


"derrick" wrote:

> Hi,
>
> I have about a 100 workbooks all with the same VBA code in them. I
> need to change a line in the VBA code in each of them and would like
> to use code rather than opening each of the workbooks and changing it.
>
> Can this be done? I just need the code to reference the line and make
> the change - I have the code to open each workbook and close it
> already in a directory.
>
> Thanks,
> Derrick
>