Monthly Archives: June 2012

How to Send Email Automatically from Excel

Hello friends, In the previous Article, you learnt how to Schedule a Program in Windows. In this article you are going to learn, How can we send email from Excel on a Scheduled date and Time automatically without any manual intervention. I have taken an Example from Live Scenario, where you want to send an Email on a daily basis [...]

How to Schedule a Task in Windows 7

This article is not related to Excel Macro. This is useful when you want to do some Job by excel Macro automatically. For example, if you want to send an Email Every Day automatically, without any manual intervention, then this task scheduling will come in to the picture. If you want to know how to Send Email Automatically from your [...]

By |Categories: Excel Macro|Tags: |5 Comments

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 Tips : Enter Current Date Without Typing in to the Cell

This is really a very small Tip but it is really interesting. If you want to enter current date in to a Cell then need not to remember the Current Date and Type it in the Cell. You Just Need to do the Following: Select the Cell and Press Ctrl + ;

By |Categories: Excel Tips|Tags: |0 Comments

Entering the Current Date into a Cell

Some times while dealing with Excel Workbook, you may need to fill a Cell with the Current Date. In such case you need to change the Cell Value every day with the current date. Using the below small trick, you can make it automated. It means Cell will be always populated with the Current Date. Use the below formula in [...]

By |Categories: Excel Tips|Tags: |0 Comments

Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)

Dear Friends,   Let's take a brief re-cap of what all things you have studied so far in Excel Macro Tutorial. So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials. You have learnt about all the Controls available in Excel Macros and also how to use them? You have also learnt How to [...]

By |Categories: Excel Macro|Tags: , , , |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 [...]

How to Declare a Public Variable in VBA

While programming in VBA sometimes you need to declare a Public Variable which can store the value through out the program. Use of Public Variable : Let's say you have 4 different Functions in your VBA Code or Module and you have a variable which may or may not be modified in any of the Functions during the execution. But [...]

By |Categories: Excel Tips|0 Comments