Get Collection of Files in Folder

[sdday81]

Hello, I'm working on a project that requires me working with files and directories. I haven't had any issues yet with setting up user forms, letting users set file paths to folders or even selecting and importing files, etc... but I'm not sure how to grab all the files in a particular folder. I'm a little new to VBA, but not programming.

I used to do stuff like this all the time in C# and C++. In C# you could grab all the files from a folder and then have a collection to loop through rename or do whatever you wanted with them. I'm looking for something similar in VBA.

I'm assuming I would use a FileDialog object, but that's about all I know right now.

 

[AngelJ]

If you just want to iterate through the files in a folder the Dir function should suffice: Dir Function

If you need something to do other kind of file manipulation then I would use FileSystemObject (which is in the Microsoft Scripting Runtime Library): FileSystemObject Reference (Windows Scripting)

 

[sdday81]

Thanks. I will give the Dir Function a try first and see if it will work, if not I'll try the File System Object. How would I add the reference into excel for the FileSystemObject? Would I add it in here or is there a way to include/reference the library in code?



-- removed inline image ---

 

[sdday81]

My Image didn't link before, but this is what I was trying to link:

 

[AngelJ]

Yup, just check that box. That would be the equivalent of importing a library in a C++ project and #include'ing the appropriate header files.

 

[sdday81]

Thanks again.