+ Reply to Thread
Results 1 to 1 of 1

Any definitive way to pull tables into word with xml?

  1. #1
    Registered User
    Join Date
    04-11-2011
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Any definitive way to pull tables into word with xml?

    I have an interesting problem. I work in the pharmaceutical/engineering industry and we often need to develop tests for processes... These tests are very time consuming to make, and much of the time is spent wrestling with word documents. The fields in the tables used are generally a description of the test to be carried out, then the expected result, a place to write, a yes/no set of checkboxes, and a place to initial and date. ((Please see attached image))

    I'd much rather make this material in excel, or access, and import complete tables into Excel. The screenshot is from a 200+ page document.

    I was thinking of using the section numbering as a xml tag, and using that tag to populate tables, or better yet, a table that expanded and shrank to the right size.

    How easy is this to pull off? I think that the toughest part is probably building the XML schemas required.

    At that point can I use VB scripting to automatically expand the table to the right size? Will tables like that wrap correctly? Can I build the wrap options into the word template that I'm planning on using?

    If I can figure this out, I'll save hundreds of hours over the next year! Is this possible? Is there a better approach? It's important that the documentation can be updated automatically when I change the original xlsx or db file.

    Any ideas on xml files I could use to accomplish this, or relevant examples?

    Thanks!!

    Bruce Schaller
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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