I am not quiet sure if this is possible or not, but I am updating from 32 bit to 64 bit excel, and there is a little of a language change between the two. I have many reports that need updating, and going into each file and find and replace would take really long.
I need a macro to do the following in order:
- Open a report from specified folder
- search within the visual basic codes
- Find and replace a specified text
- save and close the file
- Move on to the next report
Thanks, Saima
I have a code that searched through the workbook but not the VBA, i need the code to work for text embedded in the VBA.
