Assign Files in Folder to Variable

[BWAT]

Hello, I am wondering if it is possible through VBA to assign all files in an existing folder(I assume using an array) to a variable...but instead of using a file dialog box, have Access automatically store the contents of the folder. The point is to not have to stop the program for a user to select the files, but have it run through to the end. Then I could have it sort through the files using a counter or something. Ive looked and looked. Any help would be appreciated.

 

[KenHigg]

7.8 here may help:

http://books.google.com/books?id=Nh...g=zu4YRVqUtPn7fcx_fbhknZm0Ypo&hl=en#PPA334,M1

 

[BWAT]

Thanks Ken, the sad part is that book is about 2 ft behind me. I am going to look at that.

 

[dejones923]

Use FileSystemObject

I recommend referencing "Microsoft Scripting Runtime" library and use the "Scripting.FileSystemObject" to do what you need.