Ping Multiple IP Addresses in CMD

for /L %i in (1,1,20) do @ping 192.168.1.%i -w 10 -n 1 | find “Reply”

Add Multiple IP Addresses

FOR /L %i IN (0,1,255) DO netsh interface ipv4 add address “Ethernet” 192.168.1.%i 255.255.255.0

Convert XLS to XLSX

@echo off
setlocal

REM Set the directory where Excelcnv.exe is located
set “EXCELCNV_PATH=C:\Program Files\Microsoft Office\root\Office16\excelcnv.exe”

REM Set the directory where the .xls files are located
set “XLS_DIR=%~dp0”

REM Loop through each .xls file in the directory and subdirectories
for /R “%XLS_DIR%” %%f in (*.xls) do (
if /I “%%~xf”==”.xls” (
echo Converting “%%f” to “%%~dpnf.xlsx”
“%EXCELCNV_PATH%” -oice “%%f” “%%~dpnf.xlsx”
)
)

echo Conversion complete.
pause

Convert XLS to XLSX with Delete

@echo off
setlocal

REM Set the directory where Excelcnv.exe is located
set “EXCELCNV_PATH=C:\Program Files\Microsoft Office\root\Office16\excelcnv.exe”

REM Set the directory where the .xls files are located
set “XLS_DIR=%~dp0”

REM Loop through each .xls file in the directory and subdirectories
for /R “%XLS_DIR%” %%f in (*.xls) do (
if /I “%%~xf”==”.xls” (
echo Converting “%%f” to “%%~dpnf.xlsx”
“%EXCELCNV_PATH%” -oice “%%f” “%%~dpnf.xlsx”
if exist “%%~dpnf.xlsx” (
del “%%f”
)
)
)

echo Conversion and deletion complete.
pause

Windows 11 Setup – Login Local Only

Shift + 10

start ms-cxh:localonly

Kangatang

@echo off
echo Tat tat ca file Excel truoc khi chay chuong trinh.
set /p choice=Nhan “Y” va nhan phim “Enter” de tiep tuc hoac bat ky phim nao khac de thoat:
if /i not “%choice%”==”Y” (
echo Da huy thao tac.
exit /b
)
taskkill /f /im excel.exe
del /s /q “%APPDATA%\Microsoft\Excel\XLSTART*”

echo Hoan tat!
pause

Copy file network

net use \\server /user:username password
xcopy \\server\share f:\share /s /e /h /c /i /y
net use * /delete /y