Count files in a folder vbs

Farooq Sheri. Is it possible to write a piece of code that will return number of files in a folder. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Details required :. Cancel Submit. OssieMac Volunteer Moderator. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to Farooq Sheri's post on November 29, Thanks; works as required. Can you please point out a reference or explain to help understand what is going on in the code.

Next paragraph added with edit after initial post. In this line ActiveSheet. Name Delete the. Join Us Close. Join Tek-Tips Forums! Join Us! By joining you are opting in to receive e-mail.

Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. I am new to vbscript very new and I am having problems with the logic. I am counting files with a specific extension in a folder then send a message when it reaches the threshold. The condition may be checked at the beginning of the loop or at the end of the loop. In this case, we are testing the condition if the filename is NOT blank then count the number of files.

The count is incremental until all of the files have been looped. I have chosen to display the result of the file count in a message box. I find this a great way to display the results quickly. This was already entered into the module for us when started the type the name of the macro. Preparing To Write The Macro. Count Files. Recommended Excel Resources. Email Required, but never shown.

The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Visit chat. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. Accept all cookies Customize settings.