Get the List of File Names from a Folder in Excel (with and without VBA)
On my first day in my job in a small consulting firm, I was staffed on a short project for three days. The work was simple. There were many folders on the network drive and each folder had hundreds of files in it. I had to follow these three steps: Select the file and copy its name. Paste that name in a cell in Excel and hit Enter. Move to the next file and repeat step 1 & 2. Sounds simple right? It was – Simple and a huge waste of time. What took me three days could have been done in a few minutes if I knew the right techniques. In this tutorial, I will show you different ways to make this entire process super fast and super easy (with and without VBA). This Tutorial Covers: Using FILES Function to Get a List of File Names from a Folder Using VBA Get a List of All the File Names from a Folder Using VBA Get a List of All the File Names with a Specific Extension Limitations of the methods shown in this tutorial: With the techniques shown below
Comments
Post a Comment