Saving EXCEL spread sheet in two locations Thread poster: 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: 20:36 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) Local time: 20:36 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 | | | 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: 20:36 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. | | |
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, 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 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 » |
| 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 » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |