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

Topic

New Reply

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 C:Documents 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.

Reply | Quote

Replies

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

AutoOpen macro’s do not always get triggered.

Steve

Reply | Quote

Yep – I’ve got code in both places actually. It works on another workstation I have here – but its running Excel 2000.

Reply | Quote

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

Reply | Quote

I think you might be right … but how to check this

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

I think you might be right … but how to check this

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

Reply | Quote

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

Reply | Quote

Yep – I’ve got code in both places actually. It works on another workstation I have here – but its running Excel 2000.

Reply | Quote

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

AutoOpen macro’s do not always get triggered.

Steve

Reply | Quote

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:

C:Documents and SettingsPieterseApplication DataMicrosoftAddIns

Reply | Quote

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:

C:Documents and SettingsPieterseApplication DataMicrosoftAddIns

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

Thank you – I will.

Reply | Quote

Thank you – I will.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

It’s Intermittent ! Sometimes it works; sometimes not! e.r.r.r.r.r.g.g.ghghghgh

Reply | Quote

It’s Intermittent ! Sometimes it works; sometimes not! e.r.r.r.r.r.g.g.ghghghgh

Reply | Quote

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

Reply | Quote