I'm very new to Excel VBA/Macros (this week) and consider myself an above average user of Excel.
I am looking for a way to find and replace text in a Word document based on data in 2 columns in Excel.
I need to search Word and find Test Case #, match that number to column A in Excel and replace it with the value in column B.
I have attached a sample of the 2 files I am working with.
So for the first one:
Word: "Test Case 1009: Create and Manage an Event"
Excel:
ID Test Case Identifier
1009 002-01
I need to replace “1009” in Word with “002-01” from Excel.
Thanks!
R/Phil
Bookmarks