force to use a specific XLA

[dirkvv]

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

 

[Tom Ogilvy]

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.

 

[dirkvv]

Can someone give me some example code?

 

[Norman Jones]

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.

 

[Norman Jones]

Hi Dirk,

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