+ Reply to Thread
Results 1 to 2 of 2

Is it possible to save an Excel file to 2 locations?

  1. #1
    Chris_7_1
    Guest

    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?

  2. #2
    Don Guillett
    Guest

    Re: Is it possible to save an Excel file to 2 locations?

    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
    [email protected]
    "Chris_7_1" <[email protected]> wrote in message
    news:[email protected]...
    > I would like to save the file on my HD and also to my Pocket PC folder for
    > synching. Do-able?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1