[AccessD] Running a Dir command from within Access vba

jack drawbridge jackandpat.d at gmail.com
Sun Mar 12 11:51:59 CDT 2017


Hi again,

Does anyone have sample vba to run a Dir command?
I'm trying to get a listing of all *.jpg files from a directory and its
subdirectories and put the list in a text file in a specific directory.

I can get this to work going to command prompt and entering the string
directly, but I want to do this from inside Access.

cd  \users\mellon\documents\testImages Dir \s\b *.jpg >MyJpgs.txt

Thanks,
jack


More information about the AccessD mailing list