How to get all files name from a folder in Excel (VBA).

In this post I will show, how to get all files name from a folder. Some times we require to type all file names from a folder. Typing for many files a time consume. So to get easily all files name we may use following procedure. Sample File Download Link. 1.       Open a new excel file. 2.       Open Visual Basic code windows (Hit “ALT+F11”). 3.       Insert...

Read More