DosTips.com

If it doesn't then check the filespec. You said your files have "ALL.xls" at the end of the name and this is what the code expects. Thanks Foxidrvie!! I got it to work. I didn't have files ending All.xls. I thought *ALL.xls would make it work on all xls files in the folder..... and then r...

Renamed the file...

Still, Have been playing around with this for an hour and still cant get it to work.....Even created some new excel files with the format to test it but it does nothing. Can anyone else pls test it and see if it works for them?

Thanks but I can't get it to work. I saved the below code in a text file as Rename.bat (removing the echo as you said.) Placed it in the folder with the file(s) to be renamed. Opened it but file does not rename. Am I doing something wrong? Code: @echo off for %%a in (*ALL.xls) do ( for /f "toke...

Hello, I have a multiple excel reports (100+) that are I get everyday. The file are named in the following format "yyyy-mm-dd_som_tin_dom_userid_Here-report-ALL.xls" I need to rename them to "Here-report-ALL.xls"" So basically I need all the files in my folder renamed with a...