Change A Line in A Module Using VBA Code
 

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

Change A Line in A Module Using VBA Code
 

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