Vb get all files in directory

Files If oFiles. Improve this answer. Justin Moser 1, 3 3 gold badges 22 22 silver badges 28 28 bronze badges. Coder Coder 1, 11 11 silver badges 13 13 bronze badges. This works! Only issue is it's a Variant Array and I need them as a string but the typecast isn't working properly. I need to open each of them after that. Its a string contained in a variant, it shouldn't be a problem to use where ever you might use a string.

Are you sure its not something else causing your error? Also I don't use arrays for lists of filenames to open later, I use a collection of files, that might work for you too. I found my problem. I was iterating through the files using For Each i in oFiles Workbook.

Open oFiles i Just had to change that to i. My bad! Thanks for the help! I can read and think I understand what the code above is doing for the most part, how would one modify the code above so that it would also grab the filenames from sub folders? You can use the built-in Dir function or the FileSystemObject.

Dir Function The Dir Function is a built-in, lightweight method to get a list of files. The benefits for using it are: Easy to Use Good performance it's fast Wildcard support The trick is to understand the difference between calling it with or without a parameter.

Files Debug. Print oFile. Don Jewett Don Jewett 1, 13 13 silver badges 26 26 bronze badges. I'm still getting them in Variant format and I'm getting all the files and not just the Excel files. Write an if statement that tests the file names Type property. Declare your variables as the correct type and they won't be variants.

One thing to consider though - the Dir reads next file when invoked. If you perform any task on a currently selected filed it might reorder files and as a result not open another file even when you expect it to do so. To avoid that read a list of files into String array and then do all the operations using that list.

It's worth knowing that the Dir method is much faster than the FSO method. After amending both methods to write to a String array since Debug. Print is itself quite slow I found that for a folder containing approx 3, files the Dir method executed in 0.

Get Files Method Reference Is this page helpful? Please rate your experience Yes No. Any additional feedback? Namespace: Microsoft. FileIO Assembly: Microsoft. Returns a read-only collection of strings representing the names of files within a directory. GetFiles String. Applies to. The code below retrieves the name and path of the folders and files in that directory using the DIR function and lists them in column A and B:.

If you need assistance with your code, or you are looking to hire a VBA programmer feel free to contact me. Also please visit my website www. Your email address will not be published.