+ Reply to Thread
Results 1 to 3 of 3

Pull data to Word control content from Excel spreadsheet

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Mesquite, Texas, USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Pull data to Word control content from Excel spreadsheet

    I'm working on a project and I'm at a loss for how to proceed. I have a Word template using control contents and an Excel spreadsheet that contains a list of red light photo enforcement violations. I am trying to link Excel to Word so that the user can select the Violation Number and it will automatically populate the control content cells. My idea is to somehow make the Violation Number a drop down box, but because there's new data added daily, the choices in the drop down box would need to be updated daily. I'd appreciate any ideas you may be able offer.

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

    Re: Pull data to Word control content from Excel spreadsheet

    Food for thought:

    How will you determine whether a violation has been created?

    Would you like to select multiple violations and create at once?

    Would you like to printout the same?

    Create a Word Template. Simply load the Violation form, Save As, Select Macro Enabled Template. Save it to the same folder where the excel file is.

    Change the path under the Create Letter button. This currently saves the Created file back into the same folder, but if this is not to your satisfaction, we can change it to another location.

    Press Alt F8 to begin.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    10-09-2012
    Location
    Mesquite, Texas, USA
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Pull data to Word control content from Excel spreadsheet

    Thanks for the idea. I was reading some similar posts and someone suggested mail merge, and that worked perfectly

+ 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. How to pull out data from Excel into WORD 2007?
    By toplisek in forum Excel General
    Replies: 3
    Last Post: 10-14-2013, 03:58 PM
  2. Replies: 0
    Last Post: 07-02-2013, 08:40 AM
  3. Macro to extract Word content control TITLES
    By lauberk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-26-2013, 04:21 PM
  4. VBA/Word picture content control causing unreadable content
    By atycks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2013, 04:51 PM
  5. Control WORD from VBA EXCEL. ┐How can I erase data?
    By internacio in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-08-2006, 09:35 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