Setting a default save folder for a template

[postitnote100]

I know how to set the default save folder in general.
You go to Tools > Options > General
and then change the default file location.

What I would like to do is set a default file location for a specifi
template. For example, I would like the default file folder for almos
every file I make in Excel to be c:\MyFiles\ but whenever you begin
new workbook from a particular template, the default file location wil
be c:\SharedFiles\

Is there any way to do this?


Thanks in advanc

 

[Dave Peterson]

Depending on what version of excel you're using, there might be an easy
workaround.

If you're using xl2002+, then you may find it easier to just add that location
to the left hand side of the
SaveAs dialog.

Point to your folder (inside the file|SaveAs dialog), then Tools|Add to "My
Places"

Then you'll have a quick shortcut to that folder. (And you can add other
folders there, too.)

If you're using xl2k, MS has a COM addin that does the same kind of thing.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q253338
INFO: Office Developer Samples and Tools Available for Download (Q253338)

Scroll about halfway down. Might make your life a little easier.