Hello I'm having a problem which is i have a lot of .Tiff files and i need to read there names and import them into excel file. In other words, i'm trying to sort all the Tiff files and import their names into excel. can anyone help me please ASAP Thank You,

Here's a little BAT file that you can use to get the info into a txt file, then import the txt file into excel. It will get you the name, file size and date and put it in a file called "spreadsheet.txt" IMPORTANT. You must run in from within the target Dir. What ever info you don't need you can delete in Excel. ------------------------------------------ @ECHO OFF REM REM MUST BE RUN FROM WITHIN THE TARGET DIR REM REM This will get the following information: REM The File Name REM The File Size REM The File Date REM Today’s Date REM Gives the user the option of getting the information FOR ALL files or REM only those created today. REM Change the file extension .tiff to suit your needs. REM REM MUST BE RUN FROM WITHIN THE TARGET DIR REM ECHO File Size File Name > spreadsheet.txt ECHO ==================== >> spreadsheet.txt ECHO. >> spreadsheet.txt :LOOP SET /P ANS=Get ONLY Files Created TODAY? Y-N-Q: IF "%ANS%"=="" ( ECHO. ECHO Please Enter [Y]es or [N]o or [Q]uit. ECHO. GOTO :LOOP ) IF /I "%ANS%"=="Y" ( GOTO :TODAYONLY ) ELSE ( IF /I "%ANS%"=="N" ( GOTO :GETALL ) ELSE ( GOTO :QUIT ) ) :TODAYONLY FOR /f "tokens=2" %%t in ( "%DATE%" ) do ( FOR /f "tokens=*" %%i in ('dir /b *.tiff') do ( FOR /f "tokens=1" %%j in ("%%~zi") do ( FOR /f "tokens=1" %%k in ("%%~ti") do ( IF %%k==%%t ( ECHO %%j %%i >> spreadsheet.txt ) ) ) ) ) GOTO:EOF :GETALL FOR /f "tokens=*" %%i in ('dir /b *.tiff') do ( FOR /f "tokens=1" %%j in ("%%~zni") do ( ECHO %%j %%i >> spreadsheet.txt ) ) GOTO:EOF :QUIT DEL spreadsheet.txt GOTO:EOF MIKE