Why not get your reporting wb to open your large addins if/as required.

In your wb's open event, or when needed

On error resume next
set wb = nothing
set wb = workbooks("myAddin.xla")
on error goto 0 ' or resume normal error handling

if wb is nothing then
set wb = workbooks.open(sFile)
end if

Regards,
Peter T


"Maury Markowitz" wrote in message
...
I have several large XLA's that need to be installed in order for our
large reporting workbooks to work correctly. We used to use AddIns for
these, but we found that Excel periodically "forgets" about them once
in a while, at which point all our code stops working.

So I decided to avoid the AddIns system, and simply place the XLAs
into the XLSTART folder. This works very well, they work just like
they were loaded through AddIns.

However, this limits the XLA to a particular user account. I'd like
these XLAs to be system-wide. I tried placing them in a hand-created
XLSTART folder in C:\Documents and Settings\All Users\Application Data
\Microsoft, but it appears that Excel ignores it. Can anyone confirm
that?

If this is the case, does anyone have any alternate locations that
might work in the same fashion? I'd like to be able to just drop the
files on the machine and go.

Maury