Results 1 to 12 of 12
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto_open in .xla addin doesn't run (Excel 2002)

    I have an .xla file not situated in the XLSTART directory but which is loaded by browsing in the Tools, Addins. Code in the Workbook_AddinInstall event runs when the Addin is installed by the user. My Problem: the code in Auto_Open only runs after the AddinInstall event. The next time I start Excel, the AddinInstall event doesn't run (the Addin is still checked on the Addin menu) and neither does the Auto_open.

    I just tried putting it in Cocuments and Settings[user name]Application DataMicrosoftExcelXLSTART and that didn't work either.

    The purpose of the Addin is to provide global utilities to all users on the network. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  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

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    Have you tried adding the code to the workbook open Event?

    AutoOpen macro's do not always get triggered.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    Yep - I've got code in both places actually. It works on another workstation I have here - but its running Excel 2000. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  4. #4
    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

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    Is the addin actually being installed? It sounds like it might not be installing and if it doesn't install it is not opening.

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    I think you might be right ... but how to check this <img src=/S/question.gif border=0 alt=question width=15 height=15>

    I have put msgbox messages in the Addin_Install event, Open event and Auto_open. They all fire when I go to the Addins dialog box and check the Addin On. But then I close Excel and start it up again .... nothing. I've been trying to figure this out for days now. I've tried lowering the macro security to low - no joy.

    I'm thinking of writing code in Personal.xls to load the Addin .... but that really defeats the purpose of having an "always available" Addin, doesn't it?

    From the silence of Loungers, I would guess that other people haven't had this problem.

    Why me <img src=/S/bouncenburn.gif border=0 alt=bouncenburn width=31 height=31>

  6. #6
    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

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    Could you be "checking" an addin with the same name as your addin?

    Check VB and see if the add in is open. If so does it have the expected code? Perhaps it is a similarly named file in a different folder.

    Steve

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

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    The addin is in the wrong place.

    files in XLSTART are always opened, so unchecking the addin from the addins list will not "remove" it.

    Put the addin in the Library folder (should be in the same folder as the XLSTART folder. On some versions, the folder is simply called "addins", in my particular case:

    Cocuments and SettingsPieterseApplication DataMicrosoftAddIns
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    Another thing:

    Do not place long code into Auto_Open, or it will fail.

    If there is a lot of code, do something like:

    Sub Auto_Open()
    Application.Ontime Now, "ContinueOpen"
    End Sub

    Sub ContinueOpen()
    'Your code
    End Sub
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    Jan - it works now! You were right. When I put the addin in the Addins folder, all is well.

    But I need to deploy this thing in a network environment. From what I've read, it seems you should be able to put the .xla anywhere and then ask the user to choose TOOLS, Addins, Browse and then browse to the correct folder and click on the Addin ... but this definitely is not working for me. <sigh>

  10. #10
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    <img src=/S/bwaaah.gif border=0 alt=bwaaah width=123 height=15> It's Intermittent ! Sometimes it works; sometimes not! e.r.r.r.r.r.g.g.ghghghgh <img src=/w3timages/censored.gif alt=censored border=0>

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

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    You could download e.g.my name manager from my site below. It contains a setup file with unprotected code you can use to install addins. Just change the names and the folders in the code.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  12. #12
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    vancouver, BC, Br. Columbia
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto_open in .xla addin doesn't run (Excel 2002)

    Thank you - I will.

Posting Permissions

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