ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Is it possible to save an Excel file to 2 locations? (https://www.excelbanter.com/new-users-excel/4803-possible-save-excel-file-2-locations.html)

Chris_7_1

Is it possible to save an Excel file to 2 locations?
 
I would like to save the file on my HD and also to my Pocket PC folder for
synching. Do-able?

Don Guillett

Here is one I use to save to a backup folder in the same folder. Modify to
suit.
Sub Backup() 'kept in personal.xls & assigned to toolbar button
On Error GoTo BackupFile
MkDir CurDir & "\Backup"
BackupFile:
With ActiveWorkbook
MyWB = .Path & "\BACKUP\" & .Name
.SaveCopyAs MyWB
.Save
End With
End Sub

--
Don Guillett
SalesAid Software

"Chris_7_1" wrote in message
...
I would like to save the file on my HD and also to my Pocket PC folder for
synching. Do-able?





All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com