+ Reply to Thread
Results 1 to 4 of 4

rename & skip records if file not found

  1. 01-04-2018, 01:39 AM #1
    sanjuss2
    sanjuss2 is offline
    Forum Contributor
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    2016 .......
    Posts
    390

    Cool rename & skip records if file not found

    Hi
    I am using following code to rename file, but now I face one problem .....

    in column E values are
    1111
    2222
    3333
    4444
    5555

    in column f
    aaaa
    bbbb
    ccccc
    dddd
    eeee

    but while executing code if there is NO file in folder having file name as 2222 then it is showing run time error 53 'File not Found' & stop process, so I want to skip that record & rename the rest...

    What I have to do to overcome.... Thanks in advance

    Please Login or Register  to view this content.
    Last edited by sanjuss2; 01-04-2018 at 01:44 AM.
    Reply With QuoteRegister To Reply
  2. 01-04-2018, 03:39 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,192

    Re: rename & skip records if file not found

    Perhaps...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 01-04-2018, 04:48 AM #3
    sanjuss2
    sanjuss2 is offline
    Forum Contributor
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    2016 .......
    Posts
    390

    Re: rename & skip records if file not found

    thanks ....
    Reply With QuoteRegister To Reply
  4. 01-04-2018, 05:41 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,192

    Re: rename & skip records if file not found

    pleasure, tx for rep +
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create sheets and rename from list + skip if already exists
    By YenteDS in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-07-2017, 09:51 AM
  2. My File Rename Macro Always Doesn't Rename the Last Three files in the list
    By Enright in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2016, 03:46 PM
  3. [SOLVED] Skip MsgBox if found error
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-10-2015, 08:59 PM
  4. Take Input from sheet 1 and find relative records in sheet 2 ; copy found records in shet3
    By Jaijk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2013, 01:09 PM
  5. Skip a 'file not found' dialogue in a loop
    By dicenn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2013, 01:08 PM
  6. Searching for a value but skip the first found value.
    By george1982 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-14-2009, 09:35 AM
  7. skip to next cell if no value is found
    By AirCav in forum Excel General
    Replies: 0
    Last Post: 02-09-2006, 01:50 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1