Saving EXCEL spread sheet in two locations Autor de la hebra: Sarah Brenchley
|
|---|
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) 
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)
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
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)
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
Local time: 02:35
español a inglés
+ ...
PERSONA QUE INICIÓ LA HEBRA
Hi Robert,
It probably is better but I really haven't a clue about macros.
Thanks for your help anyway.
| | | | | 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 » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment