software

Whenever I create an Excel workbook I would like to save it in two, or more,
locations. Is there a way to do this quickly without having to do Save As and
then clicking around my computer to reach the right location for each Save?
--
Rik Ihssen
Principal
Washington Twp. Elem.
Valparaiso, IN

You could use a macro:

option explicit
sub save3times()
with activeworkbook
.save
.savecopyas quot;C:\mybackups\quot; amp; .name
.savecopyas quot;c:\mybackups2\quot; amp; .name
end with
end sub

If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

Rik Ihssen wrote:
gt;
gt; Whenever I create an Excel workbook I would like to save it in two, or more,
gt; locations. Is there a way to do this quickly without having to do Save As and
gt; then clicking around my computer to reach the right location for each Save?
gt; --
gt; Rik Ihssen
gt; Principal
gt; Washington Twp. Elem.
gt; Valparaiso, IN

--

Dave Peterson

THis is good, but it does not let me choose where to save the initial file.
Is there any way to make the save as option come up for new documents?

quot;Dave Petersonquot; wrote:

gt; You could use a macro:
gt;
gt; option explicit
gt; sub save3times()
gt; with activeworkbook
gt; .save
gt; .savecopyas quot;C:\mybackups\quot; amp; .name
gt; .savecopyas quot;c:\mybackups2\quot; amp; .name
gt; end with
gt; end sub
gt;
gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt; Rik Ihssen wrote:
gt; gt;
gt; gt; Whenever I create an Excel workbook I would like to save it in two, or more,
gt; gt; locations. Is there a way to do this quickly without having to do Save As and
gt; gt; then clicking around my computer to reach the right location for each Save?
gt; gt; --
gt; gt; Rik Ihssen
gt; gt; Principal
gt; gt; Washington Twp. Elem.
gt; gt; Valparaiso, IN
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Maybe you could replace the .save with:
Application.Dialogs(xlDialogSaveAs).Show
Sorting data wrote:
gt;
gt; THis is good, but it does not let me choose where to save the initial file.
gt; Is there any way to make the save as option come up for new documents?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; You could use a macro:
gt; gt;
gt; gt; option explicit
gt; gt; sub save3times()
gt; gt; with activeworkbook
gt; gt; .save
gt; gt; .savecopyas quot;C:\mybackups\quot; amp; .name
gt; gt; .savecopyas quot;c:\mybackups2\quot; amp; .name
gt; gt; end with
gt; gt; end sub
gt; gt;
gt; gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt; gt;
gt; gt; Rik Ihssen wrote:
gt; gt; gt;
gt; gt; gt; Whenever I create an Excel workbook I would like to save it in two, or more,
gt; gt; gt; locations. Is there a way to do this quickly without having to do Save As and
gt; gt; gt; then clicking around my computer to reach the right location for each Save?
gt; gt; gt; --
gt; gt; gt; Rik Ihssen
gt; gt; gt; Principal
gt; gt; gt; Washington Twp. Elem.
gt; gt; gt; Valparaiso, IN
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson