![]() When you use DIR function once, it returns the first file name in a folder. What if I want to get the names of all the Excel files in the folder (or all the files – be it Excel file or not)? To give you an example, if you have an Excel file in a folder, you can use the VBA DIR function to get the name of that Excel file (or any other type of file). Use VBA DIR function when you want to get the name of the file or a folder, using their path name.
0 Comments
Leave a Reply. |