Excel VBA Downloads

Home/Excel VBA/Excel VBA Downloads

Follow This Page for More Excel VBA Downloads. You can download our Free Example Macro Files, Tools, Dashboards and Templates for practicing excel VBA and developing new tools for automating your tasks.


Excel VBA Downloads

Excel VBA Downloads helps you to learn VBA in a practical approach. Start Learning…

Example Files

15 Basic Macros for Absolute Beginners:

Excel VBA Macros for Absolute Beginners – These 15 macros provides the easiest way to understand and learn the basics of VBA to deal with Excel Objects.

ANALYSIS TABS – 15 Examples VBA Codes for Bigenners

10 Examples On Conditional Statements:

Conditional statements are the crucial to write any program to automate the any task. You will find different examples on conditional statements such as IF,For,Select and Do While statements. […]

ANALYSISTABS Examples on Conditional Statements

Sub Procedures: Simple and Parameter:

Examples on sub-procedures will help you to learn how to write a simple procedure and procedures with parameters. […]

ANALYSIS-TABS-Sub-Prcedures

ComboBox in Excel VBA:

A Simple Supermarket Application to show examples on adding new items, clearing, selecting multiple items and changing various options of ComboBox. […]

ANALYSISTABS-ComboBox (1)

ListBox in Excel VBA:

A Sample Supermarket Application to show examples on adding new items, clearing, selecting multiple items and changing various options of ListBox. […]

ANALYSISTABS-ListBox

Collections in Excel VBA:

Download the files and see the examples one Collections. Collection is an object contains group of objects having similar characteristics (with same properties and methods). […]

ANALYSIS TABS – Collections

How to Show a Form: A Simple Bonus Calculator:

In this file you will see the code to call a UserForm from your Worksheet. […]

ANALYSIS-TABS-VBA-Forms

Examples On Events:

You can find simple examples on Excel Workbook and Worksheet Events. […]

Events

Writing To a Text File and Reading From a Text File:

This example will show the procedures to export the data from Excel worksheet to a Text File and import the data from text files to a Excel worksheet.

ANALYSIS-TABS-Writing-To-a-Text-File-and-Reading-From-a-Text-File

Creating a New Workbook, Saving and Closing It:

In this sample code you can learn how to create a new workbook, save and close using VBA.

ANALYSIS-TABS-Creating-a-New-Workbook-and-Saving-It

Adding,Deleting and Naming a Worksheets:

You can find the sample code for adding a new worksheet or deleting a n existing work sheet and rename the worksheet.

ANALYSIS-TABS-Adding-and-Deleting-Worksheets

Getting Data From Closed Workbook:

You will find the procedure for importing the data from a closed workbook.

ANALYSIS-TABS-Getting-Data-From-Closed-Workbook

Getting Data From Already Opened Workbook:

You will find the procedure for importing the data from an opened workbook.

ANALYSIS-TABS-Getting-Data-From-Already-Opened-Workbook

Getting Data Using ADO:

You will find the procedure for faster way of importing the data from a closed workbook using ADO. […]

Getting Data Using ADO:

Export To PowerPoint:

This procedure explains how to export some data from Excel to PowerPoint

ANALYSIS TABS – Export To PowerPoint

Working with Charts:

You will find the procedure to create charts using VBA.

ANALYSISTABS-Charts

Example VBA Tools

Image Viewer:

This is a tool where you can select a folder which contains set of images to show as presentation/ slide show.

ANALYSISTABS-Image-Viewer

Copy Data from One Sheet to Different Sheets:

A simple to tool to copy the data from one sheet to different worksheet in the same workbook.

ANALYSISTABS – Copy Data from One Sheet to Different Sheets

TOC Creator:

This file will help you to create TOC based on your entries in Index worksheet. You can enter all your worksheet names in Column A and click a button to create worksheets and hyperlinks

ANALYSIS TABS-Create Sheets and Hyperlinks

Example Dashboards

Sample Dashboard (Sales Data)

A very basic Dashboard (explained) using sales data to analyse different metrics of the data. […]

Sample Dashboard (Sales Data):

Sample Interactive Dashboard (Sales Data)

A very basic interactive dashboard example (explained) helps you to create interactive dashboards. […]

Sample Interactive Dashboard (Sales Data):

By |January 6th, 2013|Excel VBA|41 Comments

Share This Story, Choose Your Platform!

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

41 Comments

  1. PNRao January 19, 2013 at 7:11 PM - Reply

    Hi Guys,
    Started adding the files, you can start downloading the files and use it.

    I will give the complete explanation on each file attached (hopefully with in this week) in a separate post and add that link beside the downloads, so that is is easy to discuss any thing related to that particular file or topic.

    Hope you enjoy this-Thanks!

  2. satish January 20, 2013 at 4:35 AM - Reply

    Sir,
    Thanks for uploading the files and it was easy and superb and i am waiting for more uploads in the future.

  3. Venkat M January 23, 2013 at 5:45 PM - Reply

    Hi sir,

    Thanks for uploading examples of VBA including the code that too from Basic level…

    1) I have a doubt regarding last three excel sheets which are not saved in .xlsm formate and still code is working. HOW??

    2) One more request that the Excel sheet named “Creating a new workbook,Saving and closing” code is not getting run and giving a message that Ref# is not there or excel macros are disabled.

    3) why are you using “Open VBE” code in every excel workbook????

    Kindly reply for the above doubts

    Thanks & Regards
    VENKAT

    • PNRao January 23, 2013 at 10:43 PM - Reply

      Great! Here are my answers:

      1) .xls is Excel 1997-2003 file format. If you save your file as .xls, It will work on any Excel version 1997-2003 or higher versions (2007,2010,2013).

      But you can not open .xlsm file in Excel 2003 [i.e; you can not open the higher version files (.xlsm or .xlsx) in the lower version (Excel 2003)]

      I am saving the some file as .xls, so that user can open the files in any version of Excel.

      2) It’s my mistake, please download and check it now

      3) It is just to help novice, who may not know how to open the VBA Editor

      Hope this clarifies!

      -Thanks

      • Venkat M January 24, 2013 at 11:28 AM - Reply

        Good morning sir,

        Thank you very much for your reply………

        Can you explain the Difference between Array and Loops…I mean in what scenarios we use these. Could you please explain me in terms of Interview point of and practical work scenario with better examples if possible.

        One more request that i want some of the examples on “Creating PIVOT tables” with subject explanation.

        Thanks & Regards
        VENKAT

        • PNRao January 24, 2013 at 9:54 PM - Reply

          Arrays are one type of variables where you can store the similar type of data.

          Example, if you want to store the 5 fruit names using variable, you need to use 5 string variable, instead of this you can declare an Array and store all 5 names in one array( arrFruits=Array(“Apple”,”Fine Apple”,”Kiwi”,”Grapes”, “Mango”)

          Loops (For, Do while) will help you to repeat the same type of task more than once

          Example: If you want to format the a Range contains values less than zero in red color, no need write one statement for checking one Cell. You can avoid this using loops and one statement enough to do the same task for entire Range.

          We will see these topics with more explanation in our blog soon. And will upload the examples on pivot table ASAP

          Thanks

  4. Venkat M January 24, 2013 at 12:37 PM - Reply

    Hi sir,

    Pls help me out in the following task :

    I want to copy some data from a workbook which is not saved named “Book1″ or saved WorkBook and paste into the workbook named (Attention_Feeback.xls) perticularly into sheet name “Attention_MTD”

    The above Workbook is into the following path : Note :

    Folder is on Desktop ——> ——-> ——–> —–> ——–> (Attention_Feedback.xls) ———–> SheetName (Attention_MTD)

    Regards
    VENKAT

    • PNRao January 24, 2013 at 11:48 PM - Reply

      Updated the files, please download and check the example files (Getting Data From Workbooks)

  5. Venkat M January 29, 2013 at 5:09 PM - Reply

    Hi sir,

    I am facing lot of problem in some of my official daily tasks in terms of Reporting and wasting time bcz of manual work.

    I have already sent you the attachment copy to your mail ID and kindly help me out ASAP.

    Thanks & Regards
    VENKAT

    • PNRao January 29, 2013 at 9:30 PM - Reply

      Hi Venkat,

      I have sent the solution file, call me on Sunday if you still have any questions!

      Thanks!

      • Venkat M January 30, 2013 at 7:30 PM - Reply

        Thank you very very much and can i get the exact task solution for TASK 3? like three table values should be populated dynamically. any how i will call you on Sunday morning. And can you post our last class project?. Once again thanks for your support.

        Thanks & Regards
        VENKAT

  6. PNRao January 30, 2013 at 10:11 PM - Reply

    You can try as shown in example for task-3, or we can discuss this on Sunday.

    And I will upload the final project (explained) by Sunday EOD.

    Thanks!

  7. Venkat M January 31, 2013 at 2:57 PM - Reply

    Hi sir,

    The solutions that have given for my tasks are awsome……..

    Thank you Soooo….Much

    Regards
    VENKAT

  8. Venkat M February 11, 2013 at 9:18 PM - Reply

    Hi Sir,

    Please upload more example files as all of our batch mates are waiting eagerly and getting calls frequently.

    If possible kindly do alternate instead of slice usage as most of us not having excel 2010. and it will be the best practice for us with out slices.

    Thanks & Regards
    VENKAT

  9. PNRao February 13, 2013 at 6:36 PM - Reply

    Hi Venkat,

    Sure, I will upload the files ASAP.

    I have added the Most Useful VBA Tips today, ask our friends to practice these tips.

    Thanks!

    • Venkat M February 14, 2013 at 12:57 PM - Reply

      Thank you so much sir,

      I will inform to all.

      Regards
      VENKAT

      • Venkat M February 21, 2013 at 10:56 AM - Reply

        Hi Sir,

        Tag is Nice!!!!

        “The Complete Reference For Analyst”

        Regards
        VENKAT

  10. PNRao February 21, 2013 at 11:36 PM - Reply

    Thanks Venkat!

    How is our friends, are they referring our Most Useful VBA Tips (70+ Tips, going to be 100+ Tips soon)?

    • Venkat M February 22, 2013 at 11:53 AM - Reply

      Yes Sir,

      I told to all and they are following it seems…….and all are waiting for the Last class project and iam following all of ur tips that you are uploading.It is very nice specially its good for beginers. Once again thanks for sharing your knowledge with us.

      Regards
      VENKAT

  11. PNRao March 10, 2013 at 12:48 AM - Reply

    Added a simple dashboard, click on the Read More for more explanation on this simple dashboard.

    I will create an interactive dashboard using VBA and upload it ASAP.

    Thanks-PNRao

  12. PNRao March 10, 2013 at 10:05 AM - Reply

    Done! Added a simple Interactive dashboard.
    You can have a look and ask me if you have any questions.

    Thanks-PNRao

  13. Venkat M March 11, 2013 at 11:48 AM - Reply

    Hi Sir,

    Dashboard is really nice and thank you so much for uploading with out slices for better understanding.

    Demo is really good…

    Regards
    VENKAT

  14. Venkat M March 11, 2013 at 3:16 PM - Reply

    Hi Sir,

    I want one detailed Macro example for ” To copy data from multiple work sheets to One mastersheet(Consolidation)” as well as Removing the duplicate rows in Master sheet.

    Thanks & Regards
    VENKAT

  15. PNRao March 11, 2013 at 10:29 PM - Reply

    Thanks Venkat!

    Yes, I will work on the macro and upload it ASAP.

    Thanks-PNRao

  16. Venkat M March 12, 2013 at 11:16 AM - Reply

    Hi Sir,

    I have sent you a mail in terms of small task(Creating summery table). Pls help me out.

    Regards
    VENKAT

  17. Manish Shah December 27, 2013 at 9:57 PM - Reply

    Thanks Sir for generosity, I am trying to learn VBA Macros and I am finding this site very usefull.

    • PNRao December 28, 2013 at 3:41 AM - Reply

      All the best Manish! And thanks for your comments.

      Thank-PNRao!

  18. Dashboard | Pearltrees February 27, 2014 at 7:12 AM - Reply

    […] Excel VBA Downloads – Free Example Files Tools Dashboards Templates […]

  19. bahman June 19, 2014 at 5:34 PM - Reply

    Hi
    Thank you very much for these file .
    bahman

    • PNRao June 21, 2014 at 10:08 AM - Reply

      You are welcome – bahman!

      Thanks-PNRao!

  20. Krishna November 3, 2014 at 1:15 PM - Reply

    i am in recutiment of US IT.Do u have any predefined sheets for that.

    • PNRao November 3, 2014 at 8:22 PM - Reply

      Hi Krishna,
      I do not have any predefined templates. Please let us know if you want us to prepare now.

      Thanks-PNRao!

  21. Santosh November 19, 2014 at 5:20 PM - Reply

    Hi

    Thanks for file, but can you be able provide any Excel 2003 files which has code in it, and will not work on Excel 2010.

    Actually I am dealing with VBA code changes while migrating the Excel 2003 files to Excel 2010 format, I need sample issues files for training, can you please help me with them.

    Regards
    Santosh K K

  22. Farbood February 13, 2015 at 11:40 PM - Reply

    Best web site I’v been ever seen for learning Excel VBA.
    Thank You.

    • PNRao March 2, 2015 at 7:28 PM - Reply

      Thanks You are most welocm! PNRao!

  23. Kulcan April 18, 2015 at 10:39 AM - Reply

    Hello sir , thanks for all these useful resources.

  24. Kamesh K July 30, 2015 at 12:49 PM - Reply

    Hello MR PNR,

    I need your assistance for creating a macro which can take a screenshot and then convert in to pdf of a link(s) in website and also download excel files in those links.

    If it is not possible by a macro, please also advise if there is any other way to do it.

    I can send you a detailed explanation with screenshots..however i dont see anyoption to send files.

    Regards
    Kamesh

  25. Darell November 13, 2015 at 1:41 AM - Reply

    I have a problem, I would like to copy directory files from File Explorer and paste into a worksheet in Excel. I am using MS Windows 8.1 and Excel 2016. Can you help me out? Thanks!

  26. Nayan Narnoli February 9, 2016 at 4:36 PM - Reply

    PN Rao sir. Great work and superb explanations. Salute to you..
    I am getting stuck in VBA basically i want to download file from internet on daily basis but my path is getting change everyday bcoz path is linked with date.
    How to create a macro using date wise file download.

    bhavcopydownload
    Sub Downloadfilesfromnet()
    Dim URL As String
    Set IE = CreateObject(“internetexplorer.application”)
    URL = “http://www.nseindia.com/content/fo/fii_stats_08-Feb-2016.xls”
    Dim IEa As Object
    IE.Visible = True
    IE.Navigate URL
    Do While IEa.ReadyState
    DoEvents
    Loop
    SendKeys “%S”
    IE.ExecWB OLECMDID_SAVEAS, OLECMDEXECOPT_DODEFAULT ‘open
    End Sub

  27. MuhammadAamir February 1, 2017 at 7:15 PM - Reply

    in help
    Extract data out of 3 columns and put the data into 3 new columns by VBA

Leave A Comment