G
Guest
All,
I have a large set of excel files with which I need to add a VB module
then Find and Replace existing VB code with new VB code. Is there a way to
do this programmatically? In other words I don't want to manually open every
Excel file, add the module, and then run the Find and Replace. Instead I’d
like to build a program/script to handle it all. Any help would be
appreciated. Thanks in advance!
I have a large set of excel files with which I need to add a VB module
then Find and Replace existing VB code with new VB code. Is there a way to
do this programmatically? In other words I don't want to manually open every
Excel file, add the module, and then run the Find and Replace. Instead I’d
like to build a program/script to handle it all. Any help would be
appreciated. Thanks in advance!