Home

Welcome to Excel VBA Bot

 

Even though there are numerous websites and channels out there related to Excel, we here at Excel VBA Bot do things bit differently. We posts templates, that are related to real-time scenarios, which can be easily customized to suit ones needs. Head to our Examples section for such templates.


Below you can find an overview of all chapters. For any assistance, suggestions or Feedback head to our Contact Us page.


Basics

 

The basic topics related to Excel, such as Pivot Tables, Conditional Formatting, Charts and Tables will be covered in this section.


Formulas

 

The topics related to Excel Formulas will be covered in this section.


VBA

 

The topics related to Excel VBA, such as different methods, references, and code samples will be covered in this section.


Examples

 

In this section, you will find the simple, readily customizable templates or tools related to various real-time scenarios.


Contact Us

 

Ways to connect with us.


 



Popular posts from this blog

Basics of VBA: Message Box

Image
   Bottom Line: Learn how to  use different VBA Message Box options. Note : Sample Excel with code included below. Please make use of it. Skill Level:  Beginner Sample File:  VBA-MessageBox.xlsm   Syntax: Prompt − Required parameter, a string, that is displayed as a message in the dialog box. All the others are optional parameters. Please check the below image for more info (Credits: Microsoft) Various MessageBox options:      1. with only 'Ok' button:                                                   Code: 2.  with 'Ok' and 'Cancel' buttons:                                                  Code:      3.  with 'Abort', 'Retry' a...
Read more

Sending Gmails using Excel VBA

Image
  Bottom Line: Learn how to send Gmails using Excel VBA , with attachments and body text, to predefined or dynamic list of recipients. Important aspects such as configuration changes, that need to be done in Gmail and Visual Basic Editor , for the code to work as expected, are also covered here. Note : Macro Template and other useful links related to Gmail configuration changes are included within/at the end of the post. Please make use of them.   Skill Level: Beginner Sample File:  VbaToSendGmail.xlsm Prerequisite: Basic VBA Hands-on knowledge Gmail configuration changes Enabling Microsoft CDO for Windows 2000 Library   1. Basic VBA Hands-on knowledge: Assuming you already have some basic knowledge on how to enable Developer option, accessing different objects in Visual Basic Editor and basics programming knowledge, providing some useful links relevant to the topic. Please go through the below links to quickly brush up the concepts: Getting starte...
Read more