View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Jon is offline
external usenet poster
 
Posts: 183
Default How to edit VB code programmatically

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 Id
like to build a program/script to handle it all. Any help would be
appreciated. Thanks in advance!

--
J