Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 8th 05, 06:05 PM
postitnote100
 
Posts: n/a
Default Setting a default save folder for a template


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


  #2   Report Post  
Old July 8th 05, 09:30 PM
Dave Peterson
 
Posts: n/a
Default

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...;en-us;Q253338
INFO: Office Developer Samples and Tools Available for Download (Q253338)

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


postitnote100 wrote:

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


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting and KEEPING the default chart redbelly Charts and Charting in Excel 0 June 30th 05 02:35 PM
"Save As" folder -- can I default this to the same folder as origi Mike Excel Discussion (Misc queries) 1 June 11th 05 12:06 AM
Template in Excel prettytwin1 New Users to Excel 1 March 9th 05 09:22 PM
How to save file to a specific folder? rko281 Excel Discussion (Misc queries) 1 January 25th 05 10:43 PM
Save as Default folder Gerry Cornell Excel Discussion (Misc queries) 2 December 13th 04 06:41 PM


All times are GMT +1. The time now is 11:23 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017