View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Canoeist Canoeist is offline
external usenet poster
 
Posts: 2
Default Open a specific Word document from an Excel Macro

I am trying to use Word documents for mail merges that differ depending upon
the state to which they will be sent. I currently select the state in an
Excel worksheet from a combo box that translates the state abbreviation to a
number from 1 to 50. I use a vlookup function to convert the chosen state to
the appropriate file and path name. I need to know how to use the results of
the vlookup cell to open the indicated Word document.
--
Confused, but learning.