John Clingeleffer
asked on
VBA to return list of all files with a particular file extension across all a user's logical drives
Hello Experts,
I have an Front end/back end Access application where the end users can have multiple back end files. All these files end in ".eve". More frequently than I would like end users "forget' where the back end files have been created. I can get them a list of files on a logical drive (example C: drive) using command line window with:
CD C:\
dir *.eve /S >C:\SEMP\evefiles.txt
I am after a VBA routine to cycle through all their logical drives and list the .eve files in each drive/folder with "Last Accessed" information. I am familiar with GetLogicalDriveStrings but can't put put it all together into a single routine an end user can call simply.
I have an Front end/back end Access application where the end users can have multiple back end files. All these files end in ".eve". More frequently than I would like end users "forget' where the back end files have been created. I can get them a list of files on a logical drive (example C: drive) using command line window with:
CD C:\
dir *.eve /S >C:\SEMP\evefiles.txt
I am after a VBA routine to cycle through all their logical drives and list the .eve files in each drive/folder with "Last Accessed" information. I am familiar with GetLogicalDriveStrings but can't put put it all together into a single routine an end user can call simply.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.