LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Need help saving to multiple locations

Hello group!

I have my workbook on a server that is used by 200+ people. However, only a
handful have write access to it; all the rest can read only. I would like
to save it to two separate locations on the server (G: drive) and, as a
safety precaution, one location on the C: drive. The people with readonly
access will access "G:\MainWorkbook2.xls" while the original program will be
located under "G:\MainWorkbook.xls"

I am using the following code, but it seems to take forever to save. Is
there a quicker method, or more efficient method that I can use that will
also automatically overwrite the existing files?

My current code:

ActiveWorkbook.Save
ActiveWorkbook.SaveAs "G:\MainWorkbook2.xls"
ActiveWorkbook.SaveCopyAs "C:\MainWorkbookBackup.xls"

TIA for your help.

Mark


 
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
Multiple Users - Different PC/Locations teelee Excel Worksheet Functions 2 January 7th 10 05:37 AM
Ranking based on sum across multiple locations Ryan[_3_] Excel Worksheet Functions 1 February 28th 08 09:19 PM
Save document to multiple locations Bob[_13_] New Users to Excel 1 January 19th 08 08:29 PM
save to multiple locations simultaneously MOSwannabe Excel Discussion (Misc queries) 1 October 29th 07 07:00 PM
How do I advance filter to multiple locations at once? imills Excel Worksheet Functions 3 February 1st 06 06:12 PM


All times are GMT +1. The time now is 12:15 AM.

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

About Us

"It's about Microsoft Excel"