Run Add-In code when Add-In is referenced

**JamieMcLeod** · 11-30-2010, 02:26 PM

Is there an event fired within an Add-In when it is referenced in VBE?

I'm wanting to run some code as soon as the Add-In is referenced similar to on workbookopen.

Thanks

**romperstomper** · 11-30-2010, 03:08 PM

What kind of add-in and what exactly do you mean by referenced?

**JamieMcLeod** · 11-30-2010, 05:56 PM

A .xla add-in.

Set a reference to the add-in in the VBE. Under references.

**romperstomper** · 11-30-2010, 06:13 PM

If it's not already open, that would open it, but there is no specific event you can use for that. Why would you need it?

**JamieMcLeod** · 11-30-2010, 06:23 PM

General set up. E.g. Programmatically adding other references I require to the active workbook etc.

I was hoping there would be something similar to workbookopen but for the add-in.

**romperstomper** · 11-30-2010, 07:36 PM

Is there a reason you can't have the references set in the addin?

**JamieMcLeod** · 12-01-2010, 03:18 AM

The references need to be for the active workbook I am working on at the time.

I feel that we are deviating from the question asked.

I have a feeling the answer to my question is... No, there is no event fired and there is no clever little trick to fire code automatically when an add-in is opened??? :-( would you sat that is correct?

**snb** · 12-01-2010, 05:04 AM

There's no need for an addin to add references to your project.
So there's no connection between having loaded an Addin and doing the things you gave as an example.
But the vaguer your question the vaguer the answers. If you want specific answers please be specific in your question (which you were not in my opinion upto now).

**romperstomper** · 12-01-2010, 05:28 AM

Originally Posted by JamieMcLeod

The references need to be for the active workbook I am working on at the time.

Then you will have to add them yourself - or if it's the same ones each time, add a routine to do it.

I feel that we are deviating from the question asked.

I have a feeling the answer to my question is... No, there is no event fired and there is no clever little trick to fire code automatically when an add-in is opened??? :-( would you sat that is correct?

Yes - that's why we are deviating - trying to work out what it is you actually need and how to work around it, if possible. If you prefer a simple no, then ... no.

**JamieMcLeod** · 12-01-2010, 06:53 AM

Haha a simple no will be fine.

What I need to do is run code automatically when an add-in is referenced in the VBE. If that is not possible then what I want to do (in the bigger picture) cannot be achieved.

I have the routine to add the references, this is what needs to be fired when the add-in is referenced itself.

Thank you for you assistance though.