Using a macro to edit a macro

[Daddy Mac will make ya]

Short summary:

I want to create a macro that will open up the excel vb/macro editor
and simply edit existing subs/macros with some fairly sophisticated
search and replaces. Note: the macro actions I intend to create are
editting existing macros, not worksheet/book interactions.

Other Details:

I have taken the nessacary steps of:

-creating unique break points (commented out sections) to find where
to insert the new code snipits

-created several refference variables that can be easily replaced in a
search and replace (I was thinking about using a promt box or actual
worsheet refference cells-- not sure which is best)

-future breakpoints to repeat the same sophisticated search and
replaces.

Any Ideas:

I would appreciate any input on this issue I'm having....I'd like to
create this as an excel macro but if it can't occur that way, I'm open
to other suggestions. I'd like to have the action maybe executed
within VB or VBA and from an excel interface....I'm also considering
to create another workbook that could control the original macros from
the 1st wookbook....I hope I making this clear as possible....

Thank you in adavance,

-Doug

 

[Niek Otten]

Hi Doug,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Short summary:
|
| I want to create a macro that will open up the excel vb/macro editor
| and simply edit existing subs/macros with some fairly sophisticated
| search and replaces. Note: the macro actions I intend to create are
| editting existing macros, not worksheet/book interactions.
|
| Other Details:
|
| I have taken the nessacary steps of:
|
| -creating unique break points (commented out sections) to find where
| to insert the new code snipits
|
| -created several refference variables that can be easily replaced in a
| search and replace (I was thinking about using a promt box or actual
| worsheet refference cells-- not sure which is best)
|
| -future breakpoints to repeat the same sophisticated search and
| replaces.
|
| Any Ideas:
|
| I would appreciate any input on this issue I'm having....I'd like to
| create this as an excel macro but if it can't occur that way, I'm open
| to other suggestions. I'd like to have the action maybe executed
| within VB or VBA and from an excel interface....I'm also considering
| to create another workbook that could control the original macros from
| the 1st wookbook....I hope I making this clear as possible....
|
| Thank you in adavance,
|
| -Doug