Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Updating an Add-In (XL2003)

    I've been working on developing a utility and decided to make it an Add-In. Since saving it as an .xla file, I have continued to work on it and made changes to the VBA code. However, I now need to make a change to a formula in the worksheet of the add-in. How on earth do I open the add-in so that I can make the change? or don't I? I think I do vaguely recall something about saving a copy in .xls format...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Updating an Add-In (XL2003)

    Make sure the add-in is open/loaded (it will be invisible).
    Activate the Visual Basic Editor.
    Select the ThisWorkbook object of the add-in in the Project Explorer.
    Set its IsAddin property to False.
    This will make the workbook visible, so you can switch to Excel and edit the workbook.
    Then switch back to the Visual Basic Editor and set the IsAddin property to True again.
    Don't forget to save the add-in from the Visual Basic Editor.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Updating an Add-In (XL2003)

    YAY !!
    Many thanks...

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

    Re: Updating an Add-In (XL2003)

    I have the habit of always keeping a .xls version of an addin to do my dev work in. Then when I'm done, I save the xls using a new filename (append a build number e.g.), password protect the VBA project and then do a save-as to filetype Addin.
    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
  •