Dear Friends, Many of you who are interested in excel Macro or if you have ever tried to read and understand a VBA code, you would have seen two ways of referring a cell in Excel Macro: Using Range() To refer value of Cell D4, you can use Range("B4").Value. To know...
Results for "objects"
Excel Macro : Excel VBA code to Print the Sheet
Hello Friends, Hope you are doing well !! Thought of sharing a small VBA code to help you writing a code to print the Workbook, Worksheet, Cell Range, Chart etc. .PrintOut () Method is used to print any Excel Object. Syntax of .PrintOut Method YourObj.PrintOut(From,...
HP Quality Center – Excel Macro to Import Test Cases from QC
In this article, I am going to share the VBA code to download the test cases from QC in Excel Sheet. Here in this example, I will fetch very few important fields from QC but if you want more fields to be fetched then it can be easily done. I have categorized this VBA...
Excel Tip : How to save an Excel Addin (.xla) to Excel Workbook(.xls)
Hello Friends, This is a small excel tip to convert a .xla or .xlam file to .xls or .xlsm file. This is a simple trick but really helpful one 🙂 A file with .xla or .xlam extension is an Excel Add-Ins file format which can add new modules, extra functionalities, tabs,...
HP Quality Center – Connect to HP QC using Excel VBA
Dear Reader, This is the first article of HP QC VBA Tutorial. In this article I will show you the first step which you should know before doing any automation related to Quality Center using Excel Macro. That first step is nothing but connecting to the Quality Center...
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...
Mail Chart as Image from Outlook – VBA Code
In this article you will learn how to send a chart as picture using outlook from Excel Macro. As you know that in Outlook email, you can send an Image like a normal file attachment. In this case, receiver has to open the attachment to see the content. Since outlook...
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...
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 (=).
Distance Calculator in Excel VBA [REVISED]
Hi guys, on June 2016, google made some changesaround pricing and authentication etc. of its FREE APIs.Distance...
UDF to Convert Numbers to Letters
First of all, wouldn't it be great if we have a built-in function in Microsoft Excel to Convert Numbers to Letters? It...
40 Useful Excel Macro [VBA] examples – Part 2 of 2 [ FREE DOWNLOAD ]
Dear friends, As you see this is the second and last part of the tutorial 40 Useful Excel Macro [VBA] examples. In a...