'Find and replace certain words across multiple excel workbooks
This is my first post, but I am trying to figure out a way to write a VBA code for excel(and ideally MS Word) that would change certain cells/information across a large number of workbooks/documents.
For reference, I have about 54 Folders for specific "trades" which each contain 2 Excel documents that contain information from another project name and project number. I am simply looking for a way to write code that replace and change the project name and project number so that I could template this overall folder out for each of my projects without having to re-draft all of the interior excel docs.
For example.
Template Master Folder:
Framing Folder
Initiation Sheet:
Document Cell - "Project ABC - 123456752"
Plumbing Folder
Initiation Sheet:
Document Cell - "Project ABC - 123456752"
Electrical Folder
Initiation Sheet:
Document Cell - "Project ABC - 123456752"
All changed to ->
Template Master Folder:
Framing Folder
Initiation Workbook
Document Cell - "Project XYZ - 655555"
Plumbing Folder
Initiation Workbook:
Document Cell- "Project XYZ - 655555"
Electrical Folder
Initiation Workbook:
Document Cell- "Project XYZ - 655555"
Let me know if this makes sense and if y'all can help me with it!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|