Keith McElroy
asked on
VB Script automate Microsoft Word Table Cell Content Replace Part of Text
I have a couple hundred Microsoft Word Tables each with a cell with the following value
FY 2016
Actual
I need to increment the year and attempted this way which did not do anything:
dim newval
newval = "2017"
call replace(tbl.cell(row,2).ra nge.text," 2016",newv al)
Question: How can I modify this code so that it replaces the 2016 with 2017?
If possible I wish to keep the original text and just replace the 2016.
That way I do not loose the line break
FY 2016
Actual
I need to increment the year and attempted this way which did not do anything:
dim newval
newval = "2017"
call replace(tbl.cell(row,2).ra
Question: How can I modify this code so that it replaces the 2016 with 2017?
If possible I wish to keep the original text and just replace the 2016.
That way I do not loose the line break
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window