+ Reply to Thread
Results 1 to 2 of 2

Help with VB code for Pulling Data from excel to word document based on User Input

  1. #1
    Forum Contributor
    Join Date
    06-17-2014
    Location
    london
    MS-Off Ver
    365
    Posts
    398

    Help with VB code for Pulling Data from excel to word document based on User Input

    Hi All
    I was wondering whether someone can help with the following problem:

    I have an Excel workbook which contains Employee Ids and their score. I also have a word document saved which has various controls set up.
    My Excel workbook is called employee info and my word document in called review.

    what I need to do is for the user to open the word document and enter the employee's id and based on the Id entered it will look into the excel workbook(employee) and pull the relevant information for that employee.

    I have searched on Google and have some good tips but not sure how to allow the user to enter an Id oin word and look for that particular id to populate the form in Word.

    Any help is appreciate it

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Help with VB code for Pulling Data from excel to word document based on User Input

    Over the years, I've found two approaches that seem to work for me.

    Gather all the info in Excel and push the data out to a Word template.

    Or create a Word userform to pull the data in from Excel to disseminate.
    David
    (*) Reputation points appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Word pulling data from Excel: For-Each loop on read input
    By Phixer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2014, 04:19 PM
  2. [SOLVED] Pulling specific word from document name
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-14-2014, 07:19 PM
  3. Data Input Form with number of line items based on user input
    By j_gideon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2013, 02:54 PM
  4. VBA Help needed to create a document based on user input thru UserForm
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-15-2013, 02:45 PM
  5. how to create word document based on data in excel
    By wajwa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2012, 06:24 PM
  6. Pulling data from another excel file using user input (URGENT)
    By NissanGTR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2012, 12:01 AM
  7. Code to copy Excel data to a Word document
    By Zimbo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-09-2009, 03:30 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1