+ Reply to Thread
Results 1 to 5 of 5

VBA code to run till end of file in folder

  1. #1
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    VBA code to run till end of file in folder

    Dear experts

    Need help on vba code which is not run file not exist i am getting error like "Run time error 1004" file aug could not be found

    i want run code to next file even though file not exist in path as same which is there in list.

    i have list of file target folder like Jan,Feb,Mar..Dec i havent place file May,Aug file in path but i want run code rest of all 10 file

    rows data where compare files met same move rows data to corresponding file Jan.xlsb,feb.xlsb,Mar.xlsb,Apr.xlsb, not May so i want run to Jun.xlsb
    find the code below

    Please Login or Register  to view this content.
    find the attachment
    Attached Files Attached Files
    Last edited by MicroTees; 03-01-2016 at 04:10 PM. Reason: explain

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: need help on vba code to work on next file in path

    MicroTees It has come to our attention you have violated Rule 4 of our Forum RULES. Don't Private Message, Visitor message or email Excel questions to moderators or other members. (Or Access, Word, etc.)

    All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

    Breaking this rule is considered harassment by most of our contributors and thus cannot be tolerated. Repeat offense could lead to permanent ban, so do take this caution to heart.

    Post your question in a public thread and our many contributors will come to you to assist, especially if the title is accurate (see Rule #1) and you include a sample desensitized workbook that makes it easy for others to try and help.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    Re: need help on vba code to work on next file in path

    any experts help on this?

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: VBA code to run till end of file in folder

    Used error handler to check the existence of file.

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  5. #5
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    Re: VBA code to run till end of file in folder

    Thanks experts It work amazing!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code - File Path Error
    By mebailey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2016, 10:40 PM
  2. [SOLVED] Syntax Compile Error - How to work around this (file path doesn't exist)
    By Harribone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2015, 08:19 AM
  3. [SOLVED] VBA code to get file path
    By Liz_Biz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-03-2014, 11:51 AM
  4. Code to list the folder path and sub folder path of a specific file
    By kalai1587 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 03:51 AM
  5. Help with code: amend file path
    By jp84 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2013, 11:00 PM
  6. code relative file path?
    By Glio in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2007, 03:02 AM
  7. [SOLVED] Moved file, changed path, macros don't work
    By donbowyer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2006, 03:27 AM

Tags for this Thread

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