force to use a specific XLA
 

Hello,

let me try to explain my problem.

I have to xls-files : book1.xls and book2.xls
I also have 2 versions of an xla = c:\temp\ver1\funcs.xla and
c:\temp\ver2\funcs.xla
Now I want to open book1.xls and book2.xls on the same time, but book1
has to use the xla in ver1 and book2.xls has to use the xla in ver2.

How can I force a workbook to use a specific xla? From the moment I
open both workbooks tha both refer to the same XLA. Is it stored
somewhare in the XLS, registry,... which XLA is the 'master'?

All info, tips will be appreciated?

Regards,
Dirk

force to use a specific XLA
 

You can't have two workbooks open with the same name - an XLA is a workbook.

Addins are loaded by specifying them under Tools=Addins, or by manually
loading them, by doing it with code, or by creating a reference to it from a
workbook that is to be opened.

Suggest you change the name of one of your addins.

--
Regards,
Tom Ogilvy


"dirkvv" wrote:

Hello,

let me try to explain my problem.

I have to xls-files : book1.xls and book2.xls
I also have 2 versions of an xla = c:\temp\ver1\funcs.xla and
c:\temp\ver2\funcs.xla
Now I want to open book1.xls and book2.xls on the same time, but book1
has to use the xla in ver1 and book2.xls has to use the xla in ver2.

How can I force a workbook to use a specific xla? From the moment I
open both workbooks tha both refer to the same XLA. Is it stored
somewhare in the XLS, registry,... which XLA is the 'master'?

All info, tips will be appreciated?

Regards,
Dirk

force to use a specific XLA
 

Can someone give me some example code?

force to use a specific XLA
 

Hi Dirk,

Can someone give me some example code?

I think that you would need to supply at least a modicum of relevant detail
in order to enable a repondent to assist you.


---
Regards,
Norman

force to use a specific XLA
 

Hi Dirk,

Please ignore my reponse - the earlier posts were not visible to me!


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Dirk,

Can someone give me some example code?

I think that you would need to supply at least a modicum of relevant
detail in order to enable a repondent to assist you.


---
Regards,
Norman