run-python-script-using-batch-commands-simplemsoffice

How to Run Python Script Using Batch File

This batch file code will help to execute the python script file from any folder location. There is no need to run the python script manually when multiple python scripts are required to run. All these can be run by batch file in a single instance. And batch file can also run multiple python scripts […]

Read More
unzip-files-using-batch-file-simplemsoffice

How to Unzip Files Using a Batch File

Suppose you have a single zip file “RawData.zip” containing some other files placed in the “Source Folder” in C: drive. If you want to unzip files using batch commands then follow the below steps: Step 1: Open Notepad in your system. Step 2: Copy the below code in Notepad: 123456789101112131415161718192021222324252627REM Extracting Single Zip File @echo […]

Read More
list-file-names-using-batch-file-simplemsoffice

How to Create List of File Names Using Batch File

In this post, we will provide you with multiple batch script codes based on different criteria. We will provide you with the best and simple way to work with batch file script. If you don’t know, how to make a batch file then read How to create a Batch File? We will also provide you […]

Read More
run-multiple-batch-files-simplemsoffice

How to run multiple Batch files

This batch file code can run multiple batch files from a single folder location or multiple folder locations. Suppose you have a bunch of batch files in ‘Source Folder‘ like below: unzipfile.bat runpython.bat mergefile.bat           And so on…… And Instead of running one by one, you want to run all batch files automatically. Then follow the […]

Read More
create-and-use-batch-file-simplemsoffice

How to create and use Batch file

The batch file runs pre-defined DOS commands when it executes. We don’t need to write DOS commands every time. We just write all commands in notepad and save them as a batch file. When the batch file executes, it runs all DOS commands one by one. So we will create a batch file to copy […]

Read More
hide-all-sheets-in-excel-using-vba-simplemsoffice

How to Hide All Sheets in Excel Using VBA

Suppose you have an Excel Workbook with multiple sheets. If you want to hide all sheets except one active sheet then you can use this code. It is very easy to code. Just follow the below steps and you are done. Step 1: You have to open Visual Basic Editor in Excel. Press the key Alt+F11. Step […]

Read More