Results 1 to 7 of 7
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Place to store general code (add-in) (97&up)

    Hi All,

    I've written a small application that controls opening of company templates and input of some general data into them (phone & address information, reference code, title, etc.). The app is called by a set of buttons on a custom commandbar.


    As it is now, I've got all code in a dot file in the startup folder of Word (I want to keep it separated from Normal.dot). In essence, the application file is *NO* template, all it contains is code and userforms.

    Is this the best way to do things like this in Word?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: Place to store general code (add-in) (97&up)

    Jan,

    That sounds right to me - sounds like a valid definition for a global template.

    Gary

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Place to store general code (add-in) (97&up)

    Thanks. Glad to know I am on the right track.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Place to store general code (add-in) (97&up)

    Yes.

    As little as possible should be in the Normal template.

    Each app should bed in its own template.
    Some should be used by attacxhing to appropriate documents.

    Others should be in the Startup directory or always loaded globally.

    Others should be loaded globally only as needed.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Place to store general code (add-in) (97&up)

    Thank you for your thoughts. Good to see I am on the right track.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  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: Place to store general code (add-in) (97&up)

    Absolutely the way to do what you are trying to accomplish! You are right, a global template (add-in) looks nothing like a template! Something I've found useful to do is to include the documentation for my add-in in the template. This keeps it from being separated from the add-in and makes it easy to update when I make changes.
    Charles Kyle Kenyon
    Madison, Wisconsin

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Place to store general code (add-in) (97&up)

    Thanks!
    I like the suggestion to keep the documentation in the template.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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