Results 1 to 3 of 3
  1. #1
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Wait, how do you CREATE an add-in?

    The threads on <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=15346&page=0&view =expanded&sb=5&part=all>here's a fun one...</A> and <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=14034&page=0&view =expanded&sb=5&part=all&vc=1>how to distribute a self-made add-in</A> have been very interesting.

    I have a reasonably protected Excel97 template for distribution by e-mail to a select audience of about 40 people, and I ask:

    1. Why (for what business reasons) would I want to convert it to an add-in?

    and if the reasons are clear,

    2. How do I convert it to an add-in?
    -John ... I float in liquid gardens
    UTC -7ąDS

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wait, how do you CREATE an add-in?

    John: I have found so many problems with using addins, that I normally try to avoid them if there is another way to do it. My problems mostly center around making changes to the code once it has been used from other spreadsheets. Just this morning I opened a spreadsheet that was a couple of years old that used a function from an old addin that I wrote. The addin had since been enhanced to add some new features, and when the workbook opened, it came up with a dialog box wanting to know where the addin was, even though it was installed.

    However, the method of creating the addin depends on what version of Excel you have. On older versions, there was a menu command, on the tools menu if I remember correctly, in the VBA editor that would create the addin. On one of the fairly recent versions, that command disappeared and you now do it from the File SaveAs dialog for the workbook (NOT in the VBA editor). In the File SaveAs dialog box, just select Addin from the "File of type" drop down list (it should be the last choice), and Excel will create an addin file.
    Legare Coleman

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wait, how do you CREATE an add-in?

    John,

    I don't agree with Legare, maybe because I don't have the same experience. I like making add-ins and the add-ins I've created are used throughout my company. I have to admit that we are working with Excel 97 and not yet ready to upgrade to Excel 2000. However, at home I am working with Excel 2000, and I am using my add-ins at home. I also often create add-ins at home that I convert to Excel 97 without big difficulties. In some cases you have to pay attention to a few things (e.g. don't password protect your add-in in Excel 2000 if you want to unprotect it in Excel 97: this will not work).
    I think your "why?" can easily be answered: you make your code workbook-independent; it's always available, you don't need to open a specific workbook.
    Here are a few sites that show you how to create an Excel add-in:

    <A target="_blank" HREF=http://msdn.microsoft.com/library/techart/xlcraddns.htm
    >http://msdn.microsoft.com/library/techart/xlcraddns.htm
    </A>
    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q179/0/08.ASP>http://support.microsoft.com/support/kb/ar...s/Q179/0/08.ASP</A>
    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q211/5/63.ASP>http://support.microsoft.com/support/kb/ar...s/Q211/5/63.ASP</A>

Posting Permissions

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