Saving EXCEL spread sheet in two locations
Thread poster: Sarah Brenchley
Sarah Brenchley
Sarah Brenchley  Identity Verified
Local time: 18:37
Spanish to English
+ ...
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)
Robert Zawadzki (X)  Identity Verified
Local time: 18:37
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]


 
Robert Zawadzki (X)
Robert Zawadzki (X)  Identity Verified
Local time: 18:37
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


 
Sarah Brenchley
Sarah Brenchley  Identity Verified
Local time: 18:37
Spanish to English
+ ...
TOPIC STARTER
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)
Robert Zawadzki (X)  Identity Verified
Local time: 18:37
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.

 
Sarah Brenchley
Sarah Brenchley  Identity Verified
Local time: 18:37
Spanish to English
+ ...
TOPIC STARTER
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
Huang_Long
Israel
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.

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






Wordfast Pro
Translation Memory Software for Any Platform

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

Buy now! »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »