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
Here is a simple VBA macro code to run SQL Query from excel. And you can assign a command button to execute your query. Also, you can get the output of that query in your excel sheet very easily. So for example let the Server name as sql_server_name, the Database as database_name, and TableName as […]
Read More
I am sharing some very important SQL Commands at the beginner level. These commands are very common and useful in everyday office work if you are using SQL. So, I am sharing different types of commands with syntax. Basically, SQL is a Structured Query Language or you can say Standard Language for accessing and manipulating […]
Read More
This python script can merge multiple pdf files without any limitations. It is easy to use and can combine files in a short moment. If you have many pdf files and you want to merge them into one pdf. So, there are so many online websites and software tools that can merge pdf files into […]
Read More
This is a very useful script to unzip all zip files in a folder with a single click. You can also run this script from the batch file. With this python script code, you can unzip a single zip file and multiple zip files. And with small changes, you can either extract the files in […]
Read More
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
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
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
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
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
