Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Feb 2002
    Location
    Ecosse, Scotland
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    New Document from Template Hyperlink (97-SR2)

    I wonder if someone can help. From looking through past posts I think this is an old problem, but none of the replies have really helped my situation.

    I would like to create (either in an HTML file or Word document) a searchable Index of our hundreds of office templates. What I would like to end up with is the template name as a hyperlink which a user can click and it opens a new document based on the hyperlink. The Microsoft newsgroup gurus suggested I use MACROBUTTON fields, but with 700 or so templates this means 700 pieces of code in my document, which I am trying to avoid.

    I came across [Q244266] in Technet which told me how to create a hyperlink to a shortcut, but when I try this instead of the template being opened I get an egg timer. Nothing happens until I then try and edit the hyperlink and when I do so the template opens instead of a new document.

    If the macrobutton is the only road I can go down then so be it, but I wondered if I'm maybe missing something going the "hyperlink to shortcut" route.

    Any help would be greatly appreciated !!

  2. #2
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Eugene, Oregon, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Document from Template Hyperlink (97-SR2)

    We had a similar problem. My solution was to program a new dialog box that contains two listboxes (one showing folder names and the other showing files inside the folder). When the dialog box initializes, it "reads" all the subfolders in the Workgroup templates directory (which can be easily modified) and populates the folder name listbox; when the user selects a folder, the form "reads" all the "*.dot" files into the filename list box. When the user double-clicks the filename or clicks ok, it opens a new document based on the template.

    This gets you away from having to code each of the templates into a Macrobutton and keeps you from having to code any additions/deletions to your template library.

    If you're interested, i've attached the code...

    Hope this helps!
    Attached Files Attached Files

  3. #3
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: New Document from Template Hyperlink (97-SR2)

    Hubert,

    This is a nice piece of work - thanks for sharing it. <img src=/S/trophy.gif border=0 alt=trophy width=15 height=15>
    When all is said and done though, isn't the functionality it provides pretty similar to what the builtin FileNew dialog provides?

    Laura - another angle on this probem is: perhaps your firm has too many templates! From the user perspective, having this many template choices to wade through seems like a chore.

    Perhaps there are related groups of similar individual templates that can be combined into single templates; you can do this for example by the use of a userform which appears when the user creates a new document, allowing the user to choose which type of new document they want to create; differences in content between similar templates can be achieved in one template through use of autotexts.

    Gary

  4. #4
    Star Lounger
    Join Date
    Feb 2002
    Location
    Ecosse, Scotland
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Document from Template Hyperlink (97-SR2)

    Thanks for your help Hubert - I'll have a look at the code and have a go

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Eugene, Oregon, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Document from Template Hyperlink (97-SR2)

    Gary--

    You are completely correct that my FileNew doesn't differ much from the built-in FileNew dialog--however, it does help the users wading through all the templates when there are a lot of them (and when there are a lot of different folders) as is the case at my firm which has over 400 templates in over 30 subfolders. (The biggest issue for our users was the way Word's FileNew dialog manages the tabs when you have too many subfolders.)

    Mostly, I agree that the better solution is to combine as many templates as possible and get rid of the ones that you don't need. (It's far easier to manage in addition to being easier on the users). Another problem we have is that we have a lot of "templates" that are really just boilerplate legal documents. I'm planning to convert these into documents based on the normal.dot and then tweak my FileNew dialog box to allow it to also contain ".doc" files that would open as "read only".

    Unfortunately, the "clean-up" process when you already have hundreds of templates is just so time consuming that I'm not sure when we'll ever get to it! <img src=/S/frown.gif border=0 alt=frown width=15 height=15>

  6. #6
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,048
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: New Document from Template Hyperlink (97-SR2)

    You can write the code so that it picks up the document name from the link itself. That is, there is one macro, piece of code, for 700 different links. This assumes that you can make your links display variants in path names, even though it might be ugly.

    For a head start on this, look at the code on the MVP FAQ for macrobuttons for hyperlinks in protected forms. Instead of opening the document, you would be wanting to add a new document based on the template.

    For some other ideas you might want to take a look at my page on a templates menu for Microsoft Word.
    Charles Kyle Kenyon
    Madison, Wisconsin

  7. #7
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: New Document from Template Hyperlink (97-SR2)

    HTML presents special issues. The recent thread Generate a new doc from a dot on the web (Word 97/SR2) might help. If you are an IE shop (or NS 6+ shop), you can create categories and have the users click to expand and contract them, similar to a tree control. I have some sample code in this FAQ and we had a thread on the browser compatibility issues here. Hope this helps.

  8. #8
    Star Lounger
    Join Date
    Feb 2002
    Location
    Ecosse, Scotland
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Document from Template Hyperlink (97-SR2)

    Charles, that sounds very encouraging. I'll have a look at your suggestions today and let you know how I get on.

    Many thanks - you guys are all great for numpties like me!!

Posting Permissions

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