How can I change the VBA script for all Excel files instantly?

Dear All,

Really have a big headache now as most of my excel file have link up summary excel file which is a separate file from the form.

However our head require us to change all file name with a _C at the end for all Excel files. I have a big headache now on is there any way to search all the excel file VBA and do a find and replace function instead of manually one by one form go into VBA to change the summary file name?

Is there any macro can do the job or what other ways.

HOpe all can please help me and understand what I try to say.

Thank you very very much.

Hi Alan

Appreciate your help . However, am actually referring to the filename stated in VBA . How can I update the filename to the right one for all multiple Excel forms instead of go into each form VBA to update one by one which is very tedious. As my this Form link to a separate Excel Summary file which filename going to change to SR_Summary_PC.xls

Please see attach VBA example.


Image3.jpg

Thank you very much..