All my avid readers from Computer Programming backgrounds must be thinking is it a big deal? Like other programming languages use loop to traverse all the values of an array and spread them across rows or column. Right? If you are thinking so... you are...
Results for "date"
Email ID Syntax Validation in Excel
Dear LEM users, I got quite a few questions regarding How to enforce Email ID syntax validation in Excel. It could be in a particular cell or any textbox etc. So i thought of putting this small excel VBA tip which may help a lot in enforcing this validation....
Sending a HTML Email using Word Email Template and Excel Macros
How to Send a HTML Email using Word Email Template using Excel Macro Hi All, This is my very first post for learnexcelmacro.com. Thanks to Vishwa for roping me in for this good cause. Your Help/ comments / suggestions for improving this better. Things Needed:...
Send Sheet as a PDF attachment in Email
Dear Readers, In my previous article, you saw how to save an Excel Sheet as PDF file. Now you know, how to save an Excel Sheet as a pdf. Also, we have seen how to send the ActiveSheet as an attachment in Email. In this article, I am going to show you how to send the...
How to Export an Excel Sheet as PDF file
Dear Readers, In this article you are going to learn How to save an Excel Sheet as pdf file. Many a times we generate certain reports in an Excel Sheet but while sending that report to your boss, you want that to be saved in a PDF form. In such case you can simply...
How to Send more than one Sheet of the workbook in mail
In previous article of Send Email Tutorial using Excel Macro, you learnt how to send One Sheet (Active Sheet) as attachment in the email. In this Article you are going to learn how to send more than one Sheet from a workbook as an attachment in Email. The below...
How to Send ActiveSheet as Attachment in mail
In previous article of Send Email Tutorial using Excel Macro, you learnt how to send current workbook as attachment in the email. In this Article you are going to learn how to send the ActiveSheet as an attachment in Email. The below function sends the active sheet as...
Download Free File Manager – New Version
Hi Friends, I had 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 Formula : MATHEMATICAL Formulas
Want to know about most of the Important Formulas in Excel? Read Excel Formulas Tutorial Page. Click on the below links for to know about all these Formulas and how to use them ABS | CEILING | COMBIN | COUNTIF | EVEN | FACT | FLOOR | INT | MINVERSE | MMULT |...
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 emails from Excel on a Scheduled date and Time automatically without any manual intervention. I have taken an Example from...
Buy a coffee for the author
Download FREE Tools and Templates
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.
What is Excel Formula?
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 (=).
Excel Tip : How to Make an Excel Cell secured for Password
One of my friend wanted me to write an article on How can a person achieve making an Excel Cell behave like a password...
Spreading data across Columns in Excel Without VBA Code
In my previous article as you learnt how to split data using VBA SPLIT() function. In this Article I am going to...
Read and Write Document Properties of an excel Document – VBA
In this Article we will learn how to get document property of an excel workbook using Excel VBA. Before I jump in to...