XLA in startup path

[Nayan]

Hi,

A particular Excel addin (.xla file) in startup path did not load during
Excel application startup. Where as the other addin on the same path did load.

I moved all the code from this particular addin to a new .xla file and
copied the new XLA file in the startup path and it did load during the
startup.

I am wondering as; was my original XLA file currupted or something else may
be going on.

I am running Office 2003 on my machine.

Has anyone experienced this before?

Any feedback or suggestions are welcome.

Thanks

Nayan

 

[Jim Thomlinson]

Normally you don't put your xla's in the startup directory. The startup
directory is resevered for XLS files that will be executed on open. To the
best of my knowledge xla's in that directory will be ignored. In any case you
want to reference your addin by Selecting Tools -> Addin's -> Browse and then
find your addin. From this point forward whenever Excel is opened it will
look wherever you have pointed it for the xla file to load...

 

[Nayan]

Jim,

Thanks for the suggestion.

Here is the another scenario

I have about 2000 end users using this XLA. There is a script that copies
this XLA file in the alternate startup path on each users machine; so that
each user does not have to reference the addin manually.

For this reason I need to have this XLA in alternate startup of the
application.

While I was testing; this XLA did not started untill I moved the whole code
to a fresh XLA file.

Thanks,

Nayan

 

[Jim Thomlinson]

What is the question???

 

[Nayan]

Why the XLA did not load initially even though it had same code that this
newly created XLA has ( which loaded properly) ?

Thanks for the prompt response,

Nayan