View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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