Load xlam everytime open excel

[mp]

I used to use excel 97 or 03(not sure) computer died, new comp has excel
07. Used to have .xla that was always loaded for common vba project
code. followed the instructions for loading xlam in
07(http://peltiertech.com/WordPress/installing-an-add-in-in-excel-2007/)
excel always wants to look in it's default location
I have my code in my code location
when I browse to my location it loads but next time i open excel it's
gone again. How to make it load automatically. (used to be something
like personal.xls that always loaded or something like that)
don't want to store in excel's goofy default location

 

[GS]

mp brought next idea :

I used to use excel 97 or 03(not sure) computer died, new comp has excel 07.
Used to have .xla that was always loaded for common vba project code.
followed the instructions for loading xlam in
07(http://peltiertech.com/WordPress/installing-an-add-in-in-excel-2007/)
excel always wants to look in it's default location
I have my code in my code location
when I browse to my location it loads but next time i open excel it's gone
again. How to make it load automatically. (used to be something like
personal.xls that always loaded or something like that)
don't want to store in excel's goofy default location

You can specify which folder to load files from at startup via the
Advanced>General section of the Options dialog.

Also, any files stored here...

C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART

...will also be opened at startup.


Also, you could reuse your previous XLA rather than a new XLAM file. If
you install it as an addin via the Options dialog it will always be
available.

As for Excel defaulting to its Addins folder, that can be ignored since
you can easily browse to a location of your choosing.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[mp]

mp brought next idea :

You can specify which folder to load files from at startup via the
Advanced>General section of the Options dialog.

Also, any files stored here...

C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART

..will also be opened at startup.


Also, you could reuse your previous XLA rather than a new XLAM file. If
you install it as an addin via the Options dialog it will always be
available.

As for Excel defaulting to its Addins folder, that can be ignored since
you can easily browse to a location of your choosing.

Thanks GS, The old xla is gone with crashed harddrive...didn't have
everything recent backed up...my screw up...so have to rebuild from
scratch...
when I start excel it tries to load the addin from it's default location
(when I first saved the new xlam I thought I'd have a chance to tell it
where to save but didn't...it saved it in it's default location without
prompting. now it's stuck on that location even though i deleted the
file from there...how to make it quit looking there?

 

[mp]

mp brought next idea :

You can specify which folder to load files from at startup via the
Advanced>General section of the Options dialog.

Also, any files stored here...

C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART

..will also be opened at startup.


Also, you could reuse your previous XLA rather than a new XLAM file. If
you install it as an addin via the Options dialog it will always be
available.

As for Excel defaulting to its Addins folder, that can be ignored since
you can easily browse to a location of your choosing.

Delete addin from default location and add from new location.

Ok I finally got it fixed. Excel kept looking in the default location.
It said addin not found, delete from list? I said yes. then browsed to
new location and loaded. Next time I start excel it tries to find in
default location again, even though I'd deleted it from the list last
time(supposedly)...
Solution: discovered I had to close excel after deleting the old
location. then re open excel before adding the new location...took many
tries before I finally hit on that solution. Hope this helps someone in
future

 

[GS]

mp has brought this to us :

Delete addin from default location and add from new location.

Ok I finally got it fixed. Excel kept looking in the default location. It
said addin not found, delete from list? I said yes. then browsed to new
location and loaded. Next time I start excel it tries to find in default
location again, even though I'd deleted it from the list last
time(supposedly)...
Solution: discovered I had to close excel after deleting the old location.
then re open excel before adding the new location...took many tries before I
finally hit on that solution. Hope this helps someone in future

Yes, you would need to close Excel after deleting the first instance in
the Addins Manager. Once done, the entry is removed from the Registry.
Next runtime you can add a new instance of the addin and all works fine
going forward.

When you first created the XLAM, are you saying you did not get a file
browser window already set to Excel's Addins folder? This is where you
tell Excel where you're going to store it, by choosing your preferred
folder/filename.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[mp]

mp has brought this to us :

Yes, you would need to close Excel after deleting the first instance in
the Addins Manager. Once done, the entry is removed from the Registry.
Next runtime you can add a new instance of the addin and all works fine
going forward.

When you first created the XLAM, are you saying you did not get a file
browser window already set to Excel's Addins folder? This is where you
tell Excel where you're going to store it, by choosing your preferred
folder/filename.

that's what i was saying...but i could be wrong, maybe hit save too
fast-was expecting to see a file browser but maybe i missed
it(unfamiliar with the new version so probably just wasn't recognizing
what i was doing)

 

[mdrost77]

On 4/15/2012 6:51 PM, GS wrote:
Solution: discovered I had to close excel after deleting the old
location. then re open excel before adding the new location...took many
tries before I finally hit on that solution. Hope this helps someone in
future

THANK you!! .. worked like a charm!