VBA Scripts

create-function-in-vba-simplemsoffice

How to Create Function in Excel VBA

If you have used excel, you also probably used some excel formulas like sum, average, count, etc. But do you know that these formulas are pre-loaded functions in excel? Yes, these all are functions and you can also create your own functions in excel using VBA coding. Creating a function for you will be very […]

Read More
convert-text-files-into-excel-using-vb-simplemsoffice

How to Convert Text Files into Excel Using VBA Script

By this vba code, you can convert all text files available in a folder into excel version. This code is very simple, just put in your code window and you are done. Folder Location:¬†C:\Source Folder\ Step 1:¬†Open Excel and Press key¬†Alt+F11. It will open Microsoft Visual Basic for Applications Window. Step 2:¬†Go to¬†Insert >> Module¬†menu. […]

Read More
open-files-from-excel-list-using-vba-simplemsoffice

How to Open Files From Excel List Using VBA Script

If you have multiple files in a folder with different names and you want to open only some of them, then this simple code will help you. All file names are mentioned in excel sheet1. You can also add some working tasks in the VBA code, so it will open the file and save it […]

Read More
copy-files-from-ftp-location-using-vba-simplemsoffice

Copy Files From FTP Location Using VBA Script

Suppose you want to download files from single or multiple FTP directories to the local folder, then this code will help you. You can download all available files or particular files from the FTP folder. FTP Server Address:¬†203.55.32.44 FTP Folder Location:¬†“/HOME/Data_Files/” and “/HOME/Data_New/” Local Folder Location:¬†C:\Source Folder\FTP Files\ Step 1:¬†Open Excel and Press the key¬†Alt+F11. […]

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