Popular Articles

This is the category all the popular articles are categorized. Interested in reading all the popular reads.. this this the place

Download : Excel Macro Application to Send Multiple Emails

Hello Friends, I was getting queries on : How to send Email from Excel ? How to send Email from Gmail in Excel Macro ? How to Send Email from Yahoo in Excel Macro ? How to send email from Outlook in Excel Macro ? How to send Multiple emails using Excel Macro ? Keeping those queries in my mind, [...]

Download Free : GTIN Calculator in Excel

Hello Friends, I have created one Excel Workbook which can calculate all types of GTIN. It calculates following types of GTINs: GTIN -8 GTIN -12 GTIN -13 GTIN -14 To know more about the GTIN Calculator and How to Calculate GTIN... Read this Article If you want all GTIN calculator in Excel, download by clicking on the below download button.

By |Categories: Excel Macro, Popular Articles|Tags: |0 Comments

Download Free File Manager in Excel Macro

Hi Friends, I have created one file manager in Excel using excel macro. Basically it lists all the Files in a folder and sub-folders of any given drive in your PC. It fetches File Name, File Path, File Size, File Type, Last Modified Date of each file and list it in the Excel.   It also make a hyperlink for [...]

By |Categories: Popular Articles|0 Comments

Excel Macro Tutorial : How to Open Excel Workbook using Excel Macro

Dear Beginners,   In this article you are going to learn How to open an Excel Workbook using VBA. Before opening an already saved Excel Workbook, We need to confirm whether that Workbook is already opened or not. Why it is required to check whether that file is open or not? Answer is, In case that Workbook is already open [...]

Excel Macro Tutorial : Excel Form

Dear Beginner, In this article I am going to explain every aspects of VBA Form. User forms in Excel is really nice to see. It looks very fascinating while working with User Forms. You can build a very nice UI (User Interface) using Excel VBA Form. In this Article you are going to learn following things about VBA User Form: [...]

How to send email from Excel Macro from Outlook

This is continuation of my Previous Article you learnt How to Send Email From Excel VBA, using Gmail and Yahoo Email Account. In my Previous Article, How to send email from Excel Macro, as you saw how to send email by Excel VBA from Gmail or Yahoo In this article you are going to learn how to send an email [...]

How to Send an Email using Excel Macro from Gmail or Yahoo

Dear Readers, In this article we are going to learn how to send an email automatically by Excel Excel VBA. While executing the Excel Macro some times you may need to send some Details or Result directly to your email ID or any other ID using Excel Macro. If you have some report or details which you want to send [...]

ADO RecordCount Property – RecordSet Object

The RecordCount property returns a long value that indicates the number of records in a Recordset object. Many a times you might have observed that RecordCount Property does not return a correct number instead it always returns a number -1. RecordCount Property returns -1 because by default the Cursor is adOpenForwardOnly. To get the exact Record Count from your RecordSet [...]

Textbox first Letter in Caps and Rest other in Lowercase

If you want to automatically make first letter in Uppercase and rest of the characters in lowercase. No matter what case you are typing-in but it will be automatically done by Copying and Pasting the below Code under KeyPress Event of the Textbox Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Select Case KeyAscii Case Asc("A") To Asc("Z") If InStr(1, TextBox1.Text, Chr(KeyAscii)) [...]

SQL Connection using Excel Macros

Dear Friends, Using Excel Macros (VBA) you can connect to Databases like SQL, Oracle or Access DB. In this Article, I am going to teach you, how you can do a connection with a SQL Server. SQL databases has mainly two type of authentication : 1. Windows Authentication 2. SQL Server authentication. Here in this article, I will share VBA [...]

Page 4 of 512345