+ Reply to Thread
Results 1 to 9 of 9

Add-In not removing

  1. #1
    Registered User
    Join Date
    01-25-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    11

    Add-In not removing

    So I created a custom Add-In, but the add-in isn't removing itself when I uninstall it or when I close the program (this creates an error in saving files, so all files are getting corrupted)

    This is all the code I have running the menu bar and I can't figure out the proper closing code
    Last edited by STr83dgeboi; 02-01-2010 at 12:13 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Add-In not removing

    The code that you have posted will not corrupt any workbooks,unless your other code which is called, BUS320AC EasyHeader contain code that is problematic.

    How are you uninstalling the addin? Looks to me that whatever you do the menu will remain because there is no code to remove it. See sample menu & commandbar code here

    http://excel-it.com/vba_examples.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    01-25-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Add-In not removing

    mmmm ok, I fixed the uninstall problem...
    Last edited by STr83dgeboi; 02-01-2010 at 12:13 PM.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Add-In not removing

    Try changing your Workbook_Open code to:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  5. #5
    Registered User
    Join Date
    01-25-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Add-In not removing

    Tried that... doesn't seem to make any change.

    When I open excel from the shortcut link, it opens
    When I open excel from a saved file, it crashes and restarts

    It is the add-in Im making causing this problem, I still don't know why

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Add-In not removing

    Just to check - if you comment out the Workbook_Open code, does Excel still crash?
    If not, try adding a line at the start of the CreateMenu routine that adds a new workbook.

  7. #7
    Registered User
    Join Date
    01-25-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Add-In not removing

    sooo... I comment that out, and it still crashes... I have to go to the add-in menu and completely remove it to stop the crashing

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Add-In not removing

    You don't still have the Auto_Open code in there do you?

  9. #9
    Registered User
    Join Date
    01-25-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Add-In not removing

    sooo... I still don't know what I did, but being the thinker I am and with you guys supplying me help, I figured to remake the .xla from a new workbook setting... apperently this works and the code is solid, I just had to remake the UserForms which was quite easy

    Thanks for the help all, problem solved!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1