+ Reply to Thread
Results 1 to 2 of 2

backup file to another computer

  1. #1
    Forum Contributor
    Join Date
    09-22-2007
    Posts
    119

    backup file to another computer

    Hi,all
    how can to do . I will create the user form that when click the macro button.
    userform will show .then select my 1 of 20 boss name . and after click "ok" my excel file name "data.xls" is backup to my boss's computer the path 125346\data folder\..
    125346 is my selected boss's computer on the network
    20 boss name is in the R1:R20 in the sheet1 of file data.xls
    -125346 boss name "mr.ken"
    -125347 boss name "mr.frank"
    -125348 boss name "mr grano "
    and so on.....

    can any one help me this the ex.file


    thank.
    pichai

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Try using the macro recorder to get the basic code whilst using saveas
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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