[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,...
Results for "show"
Calculate distance between two places in Excel [With Fun]
Dear readers, Last week, I had placed an article on how to create a static google map in excel using Google Static Map API. Over this weekend, I thought of creating some fun for you in Excel using Google Maps Distance Matrix API. This article is going to be a learning...
VBA to Add Static Google Map in Excel Sheet
Dear Readers, In this article, I am going to give you a quick tip - how can you add google map in your excel workbook without opening the google map in any browser. More details about this will follow... To do that I am using Google Static Map API. I am not going...
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...
List all Folders and Sub-folders in Hierarchical Structure [FREE DOWNLOAD]
Dear Readers, Many of you were looking for a excel tool same as File Manager - which lists down all the files from each and every folders and subfolders, to list down all the folders and sub-folders under a given Main Folder Path. Therefore rather than replying to you...
Send Image of a Range from Excel embedded in Mail [Inline Image in Mail]
Dear Friends, Couple of my friends asked me about this like how can I send screenshot of a particular range area of my excel sheet embedded in my HTML mail with other texts in my email. I also got this question on Microsoft Excel forum where I answered that question...
[VIDEO] Excel VBA Tip – Hide Horizontal scroll bar in Excel
Dear Readers, Every week, I am going to publish at least one Excel VBA Tip where I will be sharing some small code snippets, tips, and tricks that will be useful for you during the development of any Excel VBA tool. YouTube Channel You can subscribe to VMLogger.com...
Button to Zoom in a Graph in Excel – [Method 2]
Hello Friends, How are you doing? I am back with my next article about "how to make a button to zoom-in and zoom-out a graph in Excel VBA". this is the second method I am going to explain you. In my previous article, I had explained about the very basic method. There...
Invoice Template [ FREE Download ]
Hello friends, There are many small businesses which are using Excel for their day-to-day management. Like Generating invoice, quotation, tracking data about customers, sales, employees etc. In nutshell complete management is done in excel spreadsheets. I manage my...
VBA Beginners: How to write macro for a Command Button
Dear Beginners, Quite a few times I was getting this question from my readers - How to associate a VBA code to a button? How to write a vba code which gets executed by clicking on a command button in excel vba. Add a button to trigger my macro and so on... Here are 3...
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...