DosTips.com

Hi aGerman

It works. Many thanks.

hi aGerman

It works. thank you.

for /f "delims=" %%a in ('dir /a-d /b "E:\MyProgramme\*.exe"') do echo %%~na

Hi aGerman It works. Thank you. Could you explain, when assume 1,2,3 and 4 options are become as a001, a003, a006, a001-a006 how will be the code changed? i.e. @echo off &setlocal :menu cls echo a001 Generate report staff echo a003 Generate report subjects echo a006 Generate report class echo a0...

Hi All E:\MyProgramme contains number of files with different extensions. I want to show only all files with .exe , Please note that display file name only. Not display extension(i.e. .exe ). Please advice me how to write bat file for above requirement. I tried following one but display files with f...

Hi All Please go through following bat file. @echo off :menu 1 Generate report staff 2 Generate report subjects 3 Generate report class 4 exit echo. set /p sample=Type option: if "%sample%"=="1" call r1.bat if "%sample%"=="2" call r2.bat if "%sample%"...

Got the answer. answer is, @echo off :menu 1 Generate report staff 2 Generate report subjects 3 Generate report class 4 exit echo. set /p sample=Type option: if "%sample%"=="1" call r1.bat if "%sample%"=="2" call r2.bat if "%sample%"=="3" c...

Hi All when run Menu.bat file, it asks about select the option? options are as follows 1 Generate report staff 2 Generate report subjects 3 Generate report class 4 exit My requirment is that when user enter incorrect option(i.e. not between 1 and 4) , I want to display message something like "y...

Hi All I want to modify following bat file based on number of requirements. My requirments are, When user enter database name, have to check entered database name in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. If it is exist then do, for %%a in (R0001.bat R0002.bat R0003.bat R0004....

Hi All I want to give different font colours for some of the texts in bat file. Please look at the following bat file. @echo off echo List of Reports echo Staff List echo Responsible Works pause I want to give red colour for "List of Report" text and green colour for both "Staff List&...

Hi All I have following bat file. I want to open some of the excel files. This task must go under Select a task title by giving echo 6) Sample Reports. when Select 6, then have to display list of Sample reports. Then user is able to give option to open for particular excel file. Path for each excel ...

Hi All

how to get bat file out put to pdf format. Are there any possibility to get bat file out put to pdf one by modifying following code.

@echo off
sqlcmd -S MY-PC1\SQLExpress -d TEST_2011 -i E:\r1.sql -o E:\r1.csv -s","
echo report is generated
pause



Thank you

Hi aGerman

I tried your code. It works. Many thanks

Hi All I have set of bat files. all bat file contain 'TEST_2011' text. I want to replace TEST_2011 with TEST_2012. My bat files names are r1.bat,r2.bat,r3.bat and r4.bat. Thing is I want to replace new text in all bat files at once. I tried following bat file to replace new text into bat files. But ...