VB.net/VSTO Excel Add-in

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

Is it possible to find and replace word s in the VBA code of a recorded macro inside the VBE (Visual Basic Editor) from
a VB.net/VSTO Excel Add-in programmatically?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Software Engineer
Top Expert 2009
Commented:
Please use the code shown in this blog to read the VBA code and then save it back to the target workbook.
Murray BrownASP.net/VSTO Developer

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial