+ Reply to Thread
Results 1 to 4 of 4

VBA to list files not appearing in column

  1. #1
    Registered User
    Join Date
    08-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    7

    Question VBA to list files not appearing in column

    Hi All,
    Hope this makes sense..
    I have a spreadsheet i use for my Movie & TV Shows Listing.
    I have the following..
    Sheet: MOVIES LIST
    Column C: FileName
    Column D: FileExt

    I have the following code that checks for the Filename&FileExt to advise if they exist (this checks my spelling etc are same as file name on NAS).
    This works perfectly as i want it.
    Please Login or Register  to view this content.
    I am after a way to display a list of Files that exist within the MOVIES folder on my NAS that are not listed in my Column C&D.

    I have tried the following which works but i then have to put
    Please Login or Register  to view this content.
    into the column next to it to show TRUE or FALSE.
    I am just after it to display within a particular Sheet extra files which are nor listed in my MOVIES LIST sheet.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: VBA to list files not appearing in column

    not tested
    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    08-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: VBA to list files not appearing in column

    Thanks Patel45...
    It works great and has picked up some files which do not exist in my Movies List.
    However it also picked up some files which do exist.
    I have looked at the spellings and Cell Formats (which all are set to Text) and can't find any difference..
    Out of 1200 files your script found 10 files which it thought did not exist in my list.
    However only 2 of these are files which did not exist.
    Not sure why though..

    Any ideas?

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: VBA to list files not appearing in column

    attach please a sample file with some important data and result, you can remove not important data

  5. #5
    Registered User
    Join Date
    08-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: VBA to list files not appearing in column

    Thanks for this..
    I have tried to copy & paste the exact spelling of the file name into the column
    it searches from but it still picks them up as they do not exist.
    But out of the so many thousand files it has only picked up those listed in the attachment.
    I have left a few file names etc in the attachment for demo purposes.

    I have just found that there is more files missing then previously stated last night.

    I've tried multiple times to add a file but it keeps having issues loading main site.
    I'm not sure if the Forum is having problems or not but it keeps failing..
    Attachment 263037
    Last edited by dagsvic; 09-05-2013 at 04:06 AM. Reason: Attachment not showing

+ 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. [SOLVED] Argument List of UDF not Appearing in Cell
    By jdmcheme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 11:46 AM
  2. please help me with a code to search a list of files in column A to folder
    By khan.washik in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-25-2012, 10:34 PM
  3. [SOLVED] Add-in Menu List not appearing in add-in tab
    By abdulgafoor2007 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-17-2012, 09:22 AM
  4. Replies: 2
    Last Post: 08-01-2012, 01:24 PM
  5. [SOLVED] Data Validation - Dropdown List Not Appearing
    By MWS in forum Excel General
    Replies: 2
    Last Post: 04-25-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1