I'm working/trying to learn how to pull NamedRanges from an Excel file and then loop the nameranges to find matches to bookmarks in Word and insert the info.

And I'll post back eventual code as I learn. But in getting started...

Do I need to actually open the excel file (from Word) to get the NamedRanges? I ask as I believe I need to first set a reference to Excel (in the VB Editor, select Tools + References).



You do need to open the file and not just able to select/point to the filename/location?

As I I would plan for this macro to be used company wide, I would have to instruct everyone to enable that feature in Word, which could be a challenge for the PC illiterate types.