vba on vba

[R.VENKATARAMAN]

sorry for this strange question. Is it possible to write a vba procedure to
change another sub. for e.g. in a sub I want to replace certain text or
number by another text or number particularly when this particular text or
number occurs a number of times.

 

[jose luis]

May be you could use one macro (macro1) to "read" when the neede
condition has been reached and "write" the desired values in th
WorkSheet. Then use the values as "input" in the other macro(macro2).


Hope this help.

Regards

jose lui

 

[R.VENKATARAMAN]

thanks. but how to write a macro to <read> or <write> second macro without
executing the second macro.

 

[Harald Staff]

Hi

See Chip's page
http://www.cpearson.com/excel/vbe.htm
on this.

HTH. Best wishes Harald

 

[R.VENKATARAMAN]

thank you Mr. Harald Staff. shall look into Pearsons web page.

 

[Rob van Gelder]

I have a "Search Replace Code" example on my website.

 

[Bob Phillips]

It can be done, as is shown at www.cpearson.com/excel/vbe.htm, but you
really should consider the other approach. Changing code dynamically is
likely to lead to problems, and will make debugging very difficult in
complex code.

--

HTH

RP

thanks. but how to write a macro to <read> or <write> second macro without
executing the second macro.