Hi

I'd like to perform a lookup from Word on a spreadsheet. How do I do this ?

Id like to perform the MATCH function on an Excel worksheet from Word but I cant figure out the syntax.

Thank you in advance.

First, you'd need to automate Excel & open the workbook, as described in this thread: https://www.msofficeforums.com/word-vba/16330-how-import-list-excel-into-drop-down.html#post46287 (to which I've previously referred you). Having done that, you'd employ Excel's 'WorkSheetFunction' method to do the match or lookup.

PS: I've merged your two threads as they're dealing with essentially the same issue. And, given the code I've previously directed you to, I can't see why you'd need any of these functions.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you

This was for a completely different purpose.

I have no doubt your code is exactly what I need, but I am a complete novice to this and my style of learning is to grasp things in small, managable bite-size chunks.

OK, but unless you say what you're trying to achieve (rather than trying to specify how), no-one can point you in the right direction.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]