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...
Results for "save"
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...
Archives
Buy a coffee for the author There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire...
What if you do not have internet ??
Wait.. this is supposed to be an Excel Blog.. right? Then why such article here? Am I going to discuss about this biggest problem of the World 😉 i.e. Internet Not Working?? Or Have I got some excel macro which will fix your Internet Connection problem. Or an Excel...
Excel Tool : Folder Structure Creator
Dear readers, In my previous article I posted an article about how to create folder in windows by Excel VBA code. That triggers me to build an Excel tool to create a hierarchical or Tree folder structure in any directory which is defined by you in excel sheet. Before...
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...
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...
Excel VBA Basics : All about Debugging Excel VBA code
Dear All, In Tutorial section for Beginners, I have written many basic articles like WHAT IS EXCEL MACRO, HOW TO WRITE IT, WHERE TO WRITE IT etc. As you know Errors are common while writing your code in VBA or in any other programming language for that matter. This is...
Complete VBA tutorial to interact with Power point Presentations – Part – 2 of 2
This is a continuation of my previous article about Interaction with Power point Slides using Excel Macro. In my previous article we learn how to create a New Power Point Presentation using Excel Macro (by creating Power Point Object). Bit of a Story about this...
Complete VBA tutorial to interact with Power point Presentations – Part – 1
[fusion_text] ear Friends, First of all, I apologize for not responding to many of your questions around dealing with PowerPoint presentations through Excel Macro. Many of you have sent me so...
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 (=).
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...
Excel Tool : Folder Structure Creator
Dear readers, In my previous article I posted an article about how to create folder in windows by Excel VBA code. That...
Invoice Template [ FREE Download ]
Hello friends, There are many small businesses which are using Excel for their day-to-day management. Like Generating...