+ Reply to Thread
Results 1 to 4 of 4

Save to multiple locations

  1. #1
    Forum Contributor
    Join Date
    11-03-2009
    Location
    Florida
    MS-Off Ver
    Excel 365
    Posts
    287

    Save to multiple locations

    I would like to be able to save my workbook to two locations whenever I hit save.
    One copy to my PC and another Read Only copy to the cloud (Onedrive or Dropbox).
    I would also like to see an error message if the cloud copy failed to post for any reason.

    Any ideas?

    Thanks

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Save to multiple locations

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-03-2009
    Location
    Florida
    MS-Off Ver
    Excel 365
    Posts
    287

    Re: Save to multiple locations

    Thanks John, that works but only one time. The second time I run it, there is an error. I guess I must first delete copy2.
    Can I do it without calling a macro? I've tried to play around with "onsave" but no joy.
    I would also like the copy to be read only.
    Last edited by Len Silva; 09-20-2016 at 01:00 PM.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Save to multiple locations

    I don't know of a way too do it without the use of a macro. You can set to read only (see below)

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Save in multiple locations
    By luizmachado in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-28-2016, 03:02 PM
  2. Save sheet to multiple locations
    By Woopwoop in forum Excel General
    Replies: 0
    Last Post: 06-26-2015, 09:26 AM
  3. At A Loss: Click Save - Saves To Multiple Locations
    By MACanada in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-16-2014, 10:04 AM
  4. Replies: 4
    Last Post: 05-22-2013, 05:35 PM
  5. Save to two different locations
    By phoztek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2011, 01:53 PM
  6. Save to multiple locations
    By flourboy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2007, 04:08 PM
  7. request macro to save file to multiple, separate locations
    By Joseph Spain in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-26-2005, 10:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1