Saving EXCEL spread sheet in two locations
Autor de la hebra: Sarah Brenchley

Sarah Brenchley  Identity Verified
Local time: 02:35
español a inglés
+ ...
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: 02:35
inglés a polaco
+ ...
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: 02:35
inglés a polaco
+ ...
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: 02:35
español a inglés
+ ...
PERSONA QUE INICIÓ LA HEBRA
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: 02:35
inglés a polaco
+ ...
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: 02:35
español a inglés
+ ...
PERSONA QUE INICIÓ LA HEBRA
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
Israel
Nuevo usuario
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






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



Forums
  • All of ProZ.com
  • Búsqueda de términos
  • Trabajos
  • Foros
  • Multiple search