Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I've written a couple of simple functions that I need to use in Excel spreadsheets to transform some text into a specific format that we use. The function works well, I created a module, coded the vba, tested it and all is good.

    The next question is, how do I make this function available in the default workbook? Everytime a .xlsx (or .xls) is opened or a new workbook is created I need it to be available. An add-in seems like a lot of effort, it's a total of three functions accross maybe 150 lines of code and will just be used on three machines. It would need to work under Excel 2007, 20003, and 2002.

    I'm looking for a really easy solution if one exists. Any help would be greatly appreciated...

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If they are functions in your personal.xls they are available to all files and open when XL does. An addin is a good route, especially if you want to share them with others.

    If you want them physically in every workbook created, they must be added to all previously created ones (and will give the macro warning!). To have them automatically in the default workbook, create a new workbook, add the functions and save as "book.xlt" (must be this name) in the XLStart or the alternate startup folder.

    Steve


  3. #3
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Just curious... if you did want to make it an add-in, how do you do that? and how would you share the add-in?

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I created an article about creating add-ins a while ago:

    www.jkp-ads.com/articles/distributemacro00.asp
    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
  •