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...
Results for "save"
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...
Excel Macro Tutorial : How to Open Excel Workbook using Excel Macro
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,...
Shortcut Keys in Microsoft Excel
Hello Friends, Here I am going to list down some useful Shortcut Keys. These keys are very useful in your day to day excel use. By making these shortcuts in practice you can do many of the things in Excel Easily. Key Description CTRL+( Unhides any hidden rows within...
How to Send ActiveWorkbook as attachment in Email
In previous Article, i had written how to Send Email from Excel Macro. In that article we had discussed how we can send any random file as an Attachment. Here in this article, you will learn how to send the ActiveWorkbook as an attachment. There could be two ways of...
Strip HTML : How to Remove HTML tags from a String in VBA
In this article I am going to write an User Defined Function (UDF) which is used to remove all HTMLs from a String Stored in Cell. It can be used as normal Inbuilt Formulas of Excel. For writing this function i have used VBScript Regular Expression to Replace all the...
How to Extract Email ID from a String in Cell
If you want to extract email ID from a String Stored in any cell, it is possible by writing a Simple UDF (User Defined Function) in Excel. After writing this UDF, you can use this function as a normal Excel Function. Follow the below Steps: 1. Open Visual Basic Editor...
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 OFFSET Function – Excel Tutorial
Dear Friends, What is OFFSET () Function? OFFSET() is a built-in function in excel which returns a range reference...
Excel Trick – Sheet Protection – Protect it and Stay Free
Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain...
Excel Trick – SMART Method to make White Background
Dear Readers, If you are a Microsoft Excel user then you must have come to a situation where you want to show...