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