+ Reply to Thread
Results 1 to 2 of 2

List files in a folder with Microsoft Scripting Runtime using VBA in Microsoft Ex

  1. #1
    Registered User
    Join Date
    07-04-2010
    Location
    Cobar, australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question List files in a folder with Microsoft Scripting Runtime using VBA in Microsoft Ex

    Hi there

    I used the below script which is fabulous tip on your forum, I have set up about 20 document registers to run on different folders for contracts. however the problem that I have is the when you run an update on the register once it opens, it recreates the lists that are already captured, I need it to just capture the new information when it comes into the folders. I thought it was doing this however I was incorrect. any help would be appreciated - some of these registers have 1 to 2 thousand files in them, so updating them again and again takes time and not to mention too much information to sort through

    Please Login or Register  to view this content.


    Hi there

    Sorry, i'm not a coder or expert - hope this helps

    I used the below script which is fabulous tip on your forum, I have set up about 20 document registers to run on different folders for contracts. however the problem that I have is the when you run an update on the register once it opens, it recreates the lists that are already captured, I need it to just capture the new information when it comes into the folders. I thought it was doing this however I was incorrect. any help would be appreciated - some of these registers have 1 to 2 thousand files in them, so updating them again and again takes time and not to mention too much information to sort through

    Please Login or Register  to view this content.
    Last edited by pike; 07-23-2010 at 12:18 AM. Reason: newbie

  2. #2
    Registered User
    Join Date
    07-04-2010
    Location
    Cobar, australia
    MS-Off Ver
    Excel 2003
    Posts
    5

    Post List files in a folder with using VBA in Microsoft Excel

    not required
    Last edited by Suej68; 08-12-2010 at 06:04 PM. Reason: new thread created

+ 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