+ Reply to Thread
Results 1 to 1 of 1

Creating a Custom Word Document Based on an Excel Template

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    834

    Creating a Custom Word Document Based on an Excel Template

    Afternoon all,

    We have an excel document that lists all of the services available and customers use drop down boxes to select what they require. We have a separate Word document that describes what each service entails. Is it possible, presumably using VBA, to create a custom abridged Word document that only shows descriptions for the services that the customer wishes to buy? Basically if the service isn't required I would like the relevant line/paragraph removed from the Word doc. There's a natural link in that the Excel doc contains the same service references as the Word doc. I should be fairly flexible on the structure of the Word doc if it aids the solution (and looks ok)? I was potentially thinking of using a custom list to itemise the services?

    Also, could the Word doc be embedded as part of the Excel doc or would they need to be stored separately? I think an embedded solution would better suit our need but I'm happy to hear what options we have available.

    If it helps, I've attached two sample workbooks. I hope that explains my situation clearly enough but if you have any questions just give me a shout.

    Cheers,

    Snook
    Last edited by The_Snook; 02-16-2022 at 01:40 PM.

+ 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. Show a list of Custom(non-default) Styles within a Word document (or template)?
    By JimmyWilliams in forum Word Formatting & General
    Replies: 3
    Last Post: 09-20-2017, 08:37 AM
  2. Excel database creates a Word document from a template based on excel data
    By llamafarmer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2017, 09:21 AM
  3. Merging excel data into a word document template
    By Tatay16 in forum Word Formatting & General
    Replies: 3
    Last Post: 11-29-2016, 06:48 PM
  4. Open a word document template through an excel vba (mac office 2011)
    By andy@2ggroup.ca in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2013, 01:36 PM
  5. Replies: 1
    Last Post: 10-17-2007, 10:28 AM
  6. link excel data to word document template
    By Haz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-15-2006, 01:35 PM
  7. Replies: 1
    Last Post: 02-03-2006, 07:25 PM

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