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 specific
template. For example, I would like the default file folder for almost
every file I make in Excel to be c:\MyFiles\ but whenever you begin a
new workbook from a particular template, the default file location will
be c:\SharedFiles\

Is there any way to do this?


Thanks in advance


--
postitnote100
------------------------------------------------------------------------
postitnote100's Profile: http://www.excelforum.com/member.php...o&userid=24585
View this thread: http://www.excelforum.com/showthread...hreadid=385649