• June 7, 2023
  •  
unhide-all-sheets-in-excel-using-vba-simplemsoffice

How to Unhide All Sheets in Excel Using VBA Script

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
run-sql-query-using-vba-simplemsoffice

How to Run SQL Query Using VBA Script

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
basic-sql-commands-simplemsoffice

Basic Commands in SQL for Beginners

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
merge-pdf-files-using-python-simplemsoffice

How to Merge PDF Files Using Python Script

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
unzip-files-using-python-simplemsoffice

How to Unzip Files Using Python Script

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
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