https://pol.proz.com/forum/office_applications/56000-saving_excel_spread_sheet_in_two_locations.html

Saving EXCEL spread sheet in two locations
Autor wątku: Sarah Brenchley

Sarah Brenchley  Identity Verified
Local time: 20:57
hiszpański > angielski
+ ...
Sep 24, 2006

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.


 

Robert Zawadzki (X)  Identity Verified
Local time: 20:57
angielski > polski
+ ...
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]


 

Robert Zawadzki (X)  Identity Verified
Local time: 20:57
angielski > polski
+ ...
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


 

Sarah Brenchley  Identity Verified
Local time: 20:57
hiszpański > angielski
+ ...
NOWY TEMAT
Thanks Robert Sep 24, 2006

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.

Thanks for your help though.
Collapse


 

Robert Zawadzki (X)  Identity Verified
Local time: 20:57
angielski > polski
+ ...
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.

 

Sarah Brenchley  Identity Verified
Local time: 20:57
hiszpański > angielski
+ ...
NOWY TEMAT
Yes Sep 24, 2006

Hi Robert,
It probably is better but I really haven't a clue about macros.
Thanks for your help anyway.


 

Huang_Long
Izrael
Saving Excel spreadsheet to many locations in a single action Feb 22

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.

Hope this helps
Collapse


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Saving EXCEL spread sheet in two locations

Advanced search






Trados Studio 2021 Freelance
The leading translation software used by over 270,000 translators.

Trados Studio 2021 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2021 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »