XLA in startup path

Nayan · 05-19-2006, 02:45 PM

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 · 05-19-2006, 03:00 PM

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...
--
HTH...

Jim Thomlinson

"Nayan" wrote:

> 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

Nayan · 05-19-2006, 03:15 PM

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" wrote:

> 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...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Nayan" wrote:
>
> > 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 · 05-19-2006, 03:20 PM

What is the question???
--
HTH...

Jim Thomlinson

"Nayan" wrote:

> 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" wrote:
>
> > 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...
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
> > "Nayan" wrote:
> >
> > > 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

Nayan · 05-19-2006, 03:25 PM

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

"Jim Thomlinson" wrote:

> What is the question???
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Nayan" wrote:
>
> > 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" wrote:
> >
> > > 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...
> > > --
> > > HTH...
> > >
> > > Jim Thomlinson
> > >
> > >
> > > "Nayan" wrote:
> > >
> > > > 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