I created an add-in (.xla extension) from a spreadsheet with quite a bit of
code. I have installed the add-in, and can see it from the Tools- Add-ins
dialog box. It also appears in the VBE Project Map.

However, I can not access the code except by associating it with a button or
command menu. When I try to access it in code, I get a "Subroutine not
defined" type of message.

Am I doing something wrong, or is the only way to access the code via a menu
command or button?

Try in the VBE making a reference via tools/references, and checking the
xla.

"John Loo" wrote in message
...
I created an add-in (.xla extension) from a spreadsheet with quite a bit of
code. I have installed the add-in, and can see it from the Tools- Add-ins
dialog box. It also appears in the VBE Project Map.

However, I can not access the code except by associating it with a button
or
command menu. When I try to access it in code, I get a "Subroutine not
defined" type of message.

Am I doing something wrong, or is the only way to access the code via a
menu
command or button?

Outstanding, thanks Bob - I know that will do it. I forgot about adding the
reference. I am at home, but will try it tomorrow in the office, I'm sure
that will fix it. Still learning my way around VBA vs. VB .Net

"Bob Umlas" wrote:

Try in the VBE making a reference via tools/references, and checking the
xla.

"John Loo" wrote in message
...
I created an add-in (.xla extension) from a spreadsheet with quite a bit of
code. I have installed the add-in, and can see it from the Tools- Add-ins
dialog box. It also appears in the VBE Project Map.

However, I can not access the code except by associating it with a button
or
command menu. When I try to access it in code, I get a "Subroutine not
defined" type of message.

Am I doing something wrong, or is the only way to access the code via a
menu
command or button?

I am having this same problem. I have created an xla add in, and now want to
use the subroutines and public variables. The .xla is added in and visible in
the project window.

I have tried to add the reference but only get the message

"Name conflict with existing module, project, or object library".

So I can't directly use the subroutines.

I can work around as :-

Application.Run("my.xla!mysubroutine", x,y,z)

but this does not allow me to access any public variables.

Does anyone have any ideas as to how I can create the reference?

Eric

"John Loo" wrote:

Outstanding, thanks Bob - I know that will do it. I forgot about adding the
reference. I am at home, but will try it tomorrow in the office, I'm sure
that will fix it. Still learning my way around VBA vs. VB .Net

"Bob Umlas" wrote:

Try in the VBE making a reference via tools/references, and checking the
xla.

"John Loo" wrote in message
...
I created an add-in (.xla extension) from a spreadsheet with quite a bit of
code. I have installed the add-in, and can see it from the Tools- Add-ins
dialog box. It also appears in the VBE Project Map.

However, I can not access the code except by associating it with a button
or
command menu. When I try to access it in code, I get a "Subroutine not
defined" type of message.

Am I doing something wrong, or is the only way to access the code via a
menu
command or button?