Thread: [Solved] Linking Word and Excel forward and backward
View Single Post
 
Old 04-12-2018, 12:33 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
Another approach is to read the worksheet into an array and interrogate the array.

With the attached example put the workbook and the document attached into the same folder and open the document. Allow the macros to run and follow the instructions on screen. Adapt the process to your workbook and document.
Attached Files
File Type: xlsx ExampleData.xlsx (8.4 KB, 9 views)
File Type: docm P120.docm (54.7 KB, 9 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote