Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Linking Word and Excel forward and backward Linking Word and Excel forward and backward
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 04-12-2018, 12:33 AM
gmayor's Avatar
gmayor gmayor is offline Linking Word and Excel forward and backward Windows 10 Linking Word and Excel forward and backward 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
 

Tags
link, vlookup

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Word and Excel forward and backward Word linking to Excel (hidden Excel) Doug Needham Word 5 11-04-2014 09:20 PM
Linking Word and Excel forward and backward Linking to word to excel Nicholas_jay Word 4 04-13-2014 10:15 PM
Linking Excel into a MS Word??? markpymm Office 0 07-05-2013 04:12 AM
Linking Word and Excel forward and backward linking to excel from word jillapass Word VBA 5 06-08-2012 01:28 AM
Linking from Excel to Word streng Word 4 10-28-2008 08:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:57 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft