Dear Friends, In this article I am going to teach you about Application.OnTime. I will also explain you the usage of this method with two examples: How to schedule a workbook to close at specified time How to Schedule a workbook to close if left idle for specified...
Results for "write"
What is Immediate Window and how to use it in Excel VBA
Dear Friends, Have you heard of Immediate Window in Excel VBA programming? Do you know how to make use of it? If you have not been using this while doing vba programming then trust me you were missing something really cool stuff which excel provided to the...
VBA to Open or Create a Password Protected Workbook
Dear Friends, Previously I have written about how to protect and un-protect a Sheet in a Workbook. In this article, I am going to cover all about protecting and unprotecting a workbook. This is going to be a short and simple article, yet informative and useful for...
VBA to Convert Contact Data in Excel to VCF format
Dear Friends, As you have learned about interacting with Text files through Excel VBA, it is time to see the usage of those methods you learned. One usage, you have already seen here, in how to export excel data in CSV format.In this article, I am going to teach you...
Top 4 VBA Methods to Export Excel data as CSV File
In this article, I am going to teach you 4 VBA Methods of - how to export data from Excel Range to a CSV file format using Excel VBA. Did you know? CSV is an abbreviation of Comma Separated Value. As the name suggests, it is clear that this file stores the tabular...
VBA Guide to Interact with Text Files – Part – 2 of 2
[fusion_text]ear Friends, I am back with the second part of the tutorial- VBA Guide to Interact with Text Files – Part – 1 of 2. This is the final part of this tutorial. In previous article,...
VBA Guide to Interact with Text Files – Part – 1 of 2
ext files are one of the simplest, lightest file types. This is the reason it is highly used in programming to store a lot of configuration-related data, logs and so many other necessary data...
Image in Signature not Displayed – Mail Sent by VBA
Dear Friends, I was keep getting this question from many of you that whenever your outlook signature has an Image then rest of the texts are displayed correctly but Image was never displayed. It was always appearing with a red cross sign (missing image) image. In...
Windows FileDialog to Select File or Folder Path in VBA
Dear friends, In my many Excel Tools, wherever there is a need for a file path to be entered from your local PC, I try to put a browse button to locate that file in your Windows PC through the windows file explorer window. It is the same window that you might have...
Button to Zoom in a Graph in Excel – [Method 1]
I wish Microsoft Excel has a built-in feature to Zoom-in and Zoom out a graph made in Excel 🙂 like many other web applications. But not to worry, you can easily create one to simulate the Zoom-in and Zoom out feature on an Excel graph. There are more than one...
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 (=).
40 Useful Excel Macro [VBA] examples – Part 1 of 2
Dear Friends, Here in this article, I have tried to consolidate some most useful and more frequently used excel macro...
Send Multiple Emails Tool – Ver 4.0 [Imp Bug fixes]
Dear friends, The version of Send Multiple Emails Tool, I released last, there was a small issue with the mail sent by...
FREE Download : Send Multiple Emails Tool – Ver 4.0
Dear LEM Readers, Here I come with a new version of Send multiple Email using Excel. Are you planning to send all of...