Delete all worksheet
VBA

Delete all blank worksheet using Personal Macro

In this article, we have create the a Personal Macro to delete all blank worksheet from active workbook. You can use this for the workbook wherein you have multiple worksheet and you want to delete the blank worksheet only. You can add a button on your excel ribbon to delete all blank worksheet from active workbook. You can add below given code in your personal macro. Option Explicit Sub Delete_Blank_Worksheets()
VBA Application with SQL Database
VBA

Excel VBA based Application with SQL database

In this article, we have created a VBA Application with SQL Database. We have used ADODB connection to connect the database. In this application we have created Insert, Update and Delete functionality and have used VBA list box to display the data. Multiple user can work on this application.   Below is the code to create the Table in SQL database Create Table TBL_Customer( CustomerId int identity(1,1), CustomerName nvarchar(50), CustomerAddress
Bulk File Creator
VBA

Bulk File Creator in Excel VBA

In this article, we have created an automation to create the bulk files for Excel, Word and PDF. Here we have used a school mark sheet template. this automation can be used for bulk Invoice creation or any other bulk file creation. Put the folder path wherein you want to create the files- [caption id="attachment_20069" align="aligncenter" width="619"] Bulk File Creator Automation[/caption] Mark sheet template – [caption id="attachment_20070" align="aligncenter" width="872"] Mark
Export All Worksheet as PDF
VBA

Export all Excel Worksheets in separate PDF files

In this article, you will learn how to Export all Excel worksheets in separate PDF files. In this macro we have used FileDialog in VBA to get the folder path. Below is the macro code which you can copy to your personal macro- Option Explicit Sub ExportAsPDF() Dim Folder_Path As String With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Select Folder path" If .Show = -1 Then Folder_Path = .SelectedItems(1) End With If Folder_Path
Goal Seek Using Macro
VBA

Goal Seek in Excel using VBA

In this article, we have used a Goal Seek to get required minimum sales to meet the Sales % target using VBA. You can use this method for other purpose also. Input your number in left table and yellow highlighted field and click on GetMinimum Sales button. Watch this step by step video to Goal Seek using VBA- Below is the macro code – Option Explicit Sub Goal_Seek() Dim sh
Loop Through Worksheets
VBA

Loop Through in Worksheets, Sheets & Chart in VBA

In this article, we have explained the difference between Chart Sheet and Worksheet in Excel. We have also explained how to loop through the Charts, Sheets and Worksheets. The difference between Chart Sheets and Worksheets A Worksheets are Sheets, but not all Sheets are Worksheets.  There are 2 types of Sheets: Worksheet: The sheet with the gridlines and cells. [caption id="attachment_18400" align="aligncenter" width="987"] Worksheet[/caption] Chart Sheet: The sheet which contains
Data Entry Application
VBA

Data Entry Application in Excel VBA

In this article, we have created a Data Entry Application with List box in Excel VBA. Data is saved in the same Excel file on Database worksheet. You can Add, Update and Delete the data. To update or delete the record double click on the record in list box and click on Update or Delete button. [caption id="attachment_17650" align="aligncenter" width="952"] Data Entry Application[/caption] Click here to download this Excel File-
VBA

Create Auto Table of Contents in Excel Workbook

In this article, you will learn how to create a Table of Contents for any active workbook using VBA. We have created VBA code which you can put in your personal macro. Below is the code to create the Table of Contents - Option Explicit Sub Create_TableOfContents() 'Check is workbook is protected If ActiveWorkbook.ProtectStructure = True Or ActiveWorkbook.ProtectWindows = True Then MsgBox "Workbook is protected. Please unprotect it first", vbCritical
Word Count in Excel
VBA

UDF to get the frequency of specific word in a Paragraph

In this article, you will learn how to create a User Defined Function in VBA to get the frequency of specific word in a paragraph. Using this UDF you will be able to get the Total Words, Specific word count (Case Sensitive Check) and Specific word count (Non-Case Sensitive Check). For example, we have below given paragraph, and we have got the Total word count and Specific word count also-
PDF to Excel Converter
Templates VBA

PDF to Excel Converter in Excel VBA

In this article, you will learn how to create a PDF to Excel converter using Excel VBA. We have created a Setting worksheet wherein we are taking 2 folders inputs on range E11 and E12 respectively. PDF Files Folder: Wherein all the PDF files are available Excel File Folder: Wherein Excel files will be saved after conversion. [caption id="attachment_15980" align="aligncenter" width="658"] Setting Sheet[/caption]   Add the Microsoft Scripting Runtime Reference