This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
Hi, What I need to do is to save an excel spreadsheet in two different locations whenever I press SAVE button in Excel. I've seen articles about macros that can do this but I don't have much experience of macros so am not sure how to go about creating one, etc. My final idea is to synchronise the file with my PDA so ideally I would like a simplified version (with only some of the columns visible/available) of the main file saved. Can anyone help? Thanks, Sarah.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Robert Zawadzki (X) Local time: 04:49 English to Polish + ...
I can write it...
Sep 24, 2006
Only I need to know where to save this copy. Or perhaps add a "Copy of " to a name. If you give me your landline (not mobile) number, I shall call you and discuss things.
[Edited at 2006-09-24 11:13]
[Edited at 2006-09-24 12:24]
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Robert Zawadzki (X) Local time: 04:49 English to Polish + ...
The macro itself
Sep 24, 2006
You only need to insert it in the right place (thisworkbook)
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean)
Application.EnableEvents = False
ThisWorkbook.Save
NewName = "Copy of " + ThisWorkbook.Name
ActiveWorkbook.SaveCopyAs NewName
Application.EnableEvents = True
Cancel = True 'cancel original save request
End Sub
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
I discovered this macro and it gives a blow-by-blow account which is what I needed:
Please try the following
1. Tools - Macro - security - security level - low Tools - Macro - security - trusted publishers- tick the two boxes at left-lower corner 2. Tools - macro - Visual Basic Editor 3. Insert module 4. Check the folders names and the filename and Copy Sub Savingtwofolders() ChDir1 = "C:\MyDocuments\" Chdi... See more
I discovered this macro and it gives a blow-by-blow account which is what I needed:
Please try the following
1. Tools - Macro - security - security level - low Tools - Macro - security - trusted publishers- tick the two boxes at left-lower corner 2. Tools - macro - Visual Basic Editor 3. Insert module 4. Check the folders names and the filename and Copy Sub Savingtwofolders() ChDir1 = "C:\MyDocuments\" Chdir2 = "C:\shared\" filename="file1.xls" ActiveWorkbook.SaveAs Filename:=chDir1+filename ActiveWorkbook.SaveAs Filename:=chDir2+filename End Sub 5. File - Close and return to Excel 6. Select the sheet where you have the part numbers 7. Tools - macro - macros select Savingtwofolders and press run or
7. make the excecution easier by inserting a button View - toolbars Activate Forms draw a command button assign this to savingtwofolders
8. Press the button
or add a new command to the File menu
(Courtesy of Adelaide on expertsabout.com)
My next challenge will be to save a simplifed version rather than the full one.
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Robert Zawadzki (X) Local time: 04:49 English to Polish + ...
I'd say my solution is better
Sep 24, 2006
When you install it the right way, it simply saves the sheet in two locations whenever you select 'Save', whether from a menu, an icon or even using a macro.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Saving Excel spreadsheet to many locations in a single action
Feb 22, 2021
Hi,
In a reference to your question, I'd like to introduce my own add-on called SOS Click and is available at https://www.sos-click.com and does what you ask for without using a macro. It allows you to save your spreadsheet (but also works with Word and PowerPoint) to multiple locations in a single click. Locations can be local like a local folder, a local hard drive, flash/thumb drive and a... See more
Hi,
In a reference to your question, I'd like to introduce my own add-on called SOS Click and is available at https://www.sos-click.com and does what you ask for without using a macro. It allows you to save your spreadsheet (but also works with Word and PowerPoint) to multiple locations in a single click. Locations can be local like a local folder, a local hard drive, flash/thumb drive and a network drive. You can also save by sending to one or more e-mail addresses as well as integrate easily with Dropbox and Google Drive. The spreadsheet will be saved to all of these places you specify with a single click. More information can be found at the site mentioned above.
The leading translation software used by over 270,000 translators.
Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop
and cloud solution, empowering you to work in the most efficient and cost-effective way.
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value