0

Is there a code that would open the VBA editor and find and replace text?

Even if it does not do find and replace, is there a code that would just open the VBA Editor?

Saima
  • 1
  • 1
  • 1
    Do you mean having a macro open an editor and making edits to another macro during runtime? – Torc Dec 08 '22 at 13:09
  • 1
    https://stackoverflow.com/questions/26509578/change-vba-coding-with-vba-coding – BigBen Dec 08 '22 at 13:56
  • 1
    http://www.cpearson.com/excel/vbe.aspx – BigBen Dec 08 '22 at 13:56
  • @Torc Yes.. so having a code that would open macro and then make changes within the script of another macro. so from one report to another if that makes sense. – Saima Dec 08 '22 at 15:55
  • @Saima, have a look at the links that BigBen posted. They'll show you how to do that – Torc Dec 08 '22 at 19:15

0 Answers0