Results 1 to 20 of 23

Thread: Use Excel To Open Word

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #12
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,954
    Location
    I put it all together for you in the XLSM file with an example DOCX. I used ADO to fill a combobox with the LastName, FirstName, EmployeeID from the Employees table in the Northwind database. I parsed the ID name from the string value in the combobox to build the SQL string. You will need to get nwind.mdb and change the paths accordingly. There are a few more routines in it than you really need. Look at the Sheet1 code which contains the code for the two command buttons.

    Here is one place to get mwind.mdb. http://www.microsoft.com/download/en....aspx?id=19704
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •