Macro to Modify Another Macro
 

I need to comment out a line in a macro that appears in
several hundred woorkbooks. Can I write a macro that will
do this? How?

I don't mind doing this one workbook at a time. In other
words, when an unmodified workbook is opened, the user
could run a macro that would make the appropriate
modifications.

Macro to Modify Another Macro
 

On Fri, 30 Jan 2004 13:01:18 -0800, "John"
wrote:

I need to comment out a line in a macro that appears in
several hundred woorkbooks. Can I write a macro that will
do this? How?

I don't mind doing this one workbook at a time. In other
words, when an unmodified workbook is opened, the user
could run a macro that would make the appropriate
modifications.

I suggest taking a look at Chip Pearson's site. Specifically:

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


---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

Macro to Modify Another Macro
 

Look at Chip Pearson's page on programming the VBE

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

--

Regards,
Tom Ogilvy

"John" wrote in message
...
I need to comment out a line in a macro that appears in
several hundred woorkbooks. Can I write a macro that will
do this? How?

I don't mind doing this one workbook at a time. In other
words, when an unmodified workbook is opened, the user
could run a macro that would make the appropriate
modifications.

Macro to Modify Another Macro
 

John,

There's some 'search replace code' on my website which could assist you with
this task.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"John" wrote in message
...
I need to comment out a line in a macro that appears in
several hundred woorkbooks. Can I write a macro that will
do this? How?

I don't mind doing this one workbook at a time. In other
words, when an unmodified workbook is opened, the user
could run a macro that would make the appropriate
modifications.