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 emails from Excel on a Scheduled date and Time automatically without any manual intervention. I have taken an Example from...
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 into the...
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...
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 ArticleIf you want all GTIN...
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...
![Excel Tips : Enter Current Date Without Typing in to the Cell [Static]](https://vmlogger.com/excel/wp-content/uploads/sites/11/2012/06/Tips-Current-Date-2-1-400x250.png)
Shortcut key to type current date in excel cell [Static] Static changes are those which does not change by opening or refreshing the excel sheet. That means once a value is typed in then it will remain as is until you or the VBA code does not change it. If you want to...
Sometimes while dealing with Excel Workbook, you may need to fill a Cell with the Current Date. In such a 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 the Cell will be always...
Let's take a brief recap of 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 learned about all the Controls available in Excel Macros and also how to use...
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,...
Many times while developing an application in Excel VBA, we need all the values stored in an excel Cell Range in an Array variable. So that at any point in time we can access the value from the array, rather than going to Excel Cell and reading it from there. Also,...
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
It is very easy to get the Reverse of a string entered by user in Excel VBA by using VBA inbuilt functionality....
In the ever-evolving landscape of software development, safeguarding personal data is paramount. Whether you're a...
Dear Readers, Last Friday, my wife, Shagun Sharma, who is a Vlogger shared an excel sheet with some data and a problem...
