I am using the command below to export to a txt file, but it missed all files with periods in part of the file name (i.e. "myfilename 2.21.2007 east_coast - (blue).xlsm" )
dir "\\USATL02ERAS40\Images\Walgreens\VSF_Ingestion\Vendor Submission XLSB All 050218\*.xls*" /A /B /S > XLSB_Walgreens_2017_3.txt
How can I capture all the files that end with the extension ( xls, xlsm, xlsb, xlsx ) and export it to a text file?
export to txt file using dir
Moderator: DosItHelp
-
- Posts: 7
- Joined: 08 May 2017 11:10
Re: export to txt file using dir
nevermind...that was not my issue. It was importing files with multiple periods... I have to go back and see what is going on.