| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLA in startup path
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XLA in startup path
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XLA in startup path
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XLA in startup path
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
XLA in startup path
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
| how to change absolute path to relative path | Excel Worksheet Functions | |||
| Startup Path | Excel Programming | |||
| Current path to Qualified Path | Excel Programming | |||
Hybrid Mode
