+ Reply to Thread
Results 1 to 5 of 5

rename & copy *.xls file in the folder then move

  1. #1
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    256

    rename & copy *.xls file in the folder then move

    Dear All,

    I need a macro that rename excel file *.xls (any name not specific) to abc.xls in the folder then move to other folder and override the existing abc.xls


    Your help would be appreciated

    Thanks
    Farrukh

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,948

    Re: rename & copy *.xls file in the folder then move

    Why not just re-save it in the other folder?
    Use the macro recorder to get the save code.
    Start the macro recorder, press F12 to saveas.

  3. #3
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    256

    Re: rename & copy *.xls file in the folder then move

    Quote Originally Posted by davesexcel View Post
    Why not just re-save it in the other folder?
    Use the macro recorder to get the save code.
    Start the macro recorder, press F12 to saveas.
    Actually the scenario is that a excel file has a link with other excel file .This main excel file is come from field to head office with different names some times xyz.xls some times 123.xls .We have a automated process that the linked file always get the data from named MASTER.XLS (FROM FIELD ) so that person in the head office always change the name xyz.xls or 123.xls to MASTER.xls . Some times a person forget to change the name in the specific folder then we have a great loss in live data.....

    help plz

    thanks
    farrukh

  4. #4
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    256

    Smile Re: rename & copy *.xls file in the folder then move

    Quote Originally Posted by davesexcel View Post
    Why not just re-save it in the other folder?
    Use the macro recorder to get the save code.
    Start the macro recorder, press F12 to saveas.
    HI Daves

    You are appreciated thanks alot for your support now i got your point thanks alot for your kind and great help.....

    Thanks alot
    Farrukh

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,948

    Re: rename & copy *.xls file in the folder then move


+ 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