Results 1 to 7 of 7
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Building a complex document (2002/2003 latest)

    We have need to build a complex document for one of our clients on a periodic basis. Much of what goes in the document is in a database, so we started with the commonly used approach of building a document with bookmarks, and then using Access to populate the document. However, since we need to do this repeatedly, we decided to build a template. Unfortunately there are nearly 100 questions that have to be answered, and there are typically 4 or 5 parts to each question that need to be answered, some of which the user must type, and for each question a comment can optionally be entered. So we ended up with about 500 bookmarks in the document, and guess what - even on a fast PC, Word will take 90 seconds or so just to open the template.

    We considered putting up a prompt that suggests the user go get a cup of coffee, etc. but thought we ought to explore other options first. Another option would be to build the document interactively, but that involves gobs of VBA, so before we take that approach I wondered if anyone else had experience with a situation like this.
    Wendell

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Building a complex document (2002/2003 latest)

    Are you sure that it is the number of bookmarks that slow the document when opening? Do you get the same thing if the bookmarks are hidden (that is - all names begin with an _underscore)?

    An alternative may be to give each question a table and use the Document.Table(#) a workout instead of looking for a bookmark. Parts could be included as rows within the table. If you set this up consistently then the code would only need to loop for each question (and subloop for question parts).
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Building a complex document (2002/2003 latest)

    Thanks for suggesting the alternative of using tables - that might do the trick. And the bookmarks were not hidden - that's a useful tip for future work. Thanks again for your suggestions.
    Wendell

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Building a complex document (2002/2003 latest)

    Any chance we can see the finished product of this? I'm not sure I'm following the solution here. I have a need to create a document based on many q/a's also, where each q might have subparts and also require a variable field to be entered - like a name.

    TIA

    Fred

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Building a complex document (2002/2003 latest)

    Unfortunately, no - this is a highly proprietary document that our client currently creates manually, and we're doing this under a non-disclosure situation. Sorry. We can however talk about the strategy we end up using when we've finished it.
    Wendell

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Building a complex document (2002/2003 latest)

    Wendell,

    >We can however talk about the strategy we end up using when we've finished it.

    That's fine. Even if the document wasn't proprietary, the generalizations on how to do this task would probably be more useful to those of us wanting to do the same KIND of thing. Looking forward to your posting on this. Any clue as to when that might be (so I know not to skip the Word Lounge during that period)?

    Thanks for offering the strategy.

    Fred

  7. #7
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Building a complex document (2002/2003 latest)

    Hi Wendell,

    did that document ever get finished?

    Fred

Posting Permissions

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