Looping through files in a directory

Here’s an alternative snippet for how to iterate through a collection of files. Lets say we want to look at every workbook in the current directory, except the currently open one, and show each sheet name we encounter. 
Here’s how

For more tips like this see Get Started Snippets
In the meantime why not join our forumfollow the blog or follow me on twitter to ensure you get updates when they are available.

Author: admin

Leave a Reply

Your email address will not be published. Required fields are marked *