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 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): |
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!
Sir,
Thanks for uploading the files and it was easy and superb and i am waiting for more uploads in the future.
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
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
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
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
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
Updated the files, please download and check the example files (Getting Data From Workbooks)
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
Hi Venkat,
I have sent the solution file, call me on Sunday if you still have any questions!
Thanks!
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
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!
Hi sir,
The solutions that have given for my tasks are awsome……..
Thank you Soooo….Much
Regards
VENKAT
Thanks Venkat!
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
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!
Thank you so much sir,
I will inform to all.
Regards
VENKAT
Hi Sir,
Tag is Nice!!!!
“The Complete Reference For Analyst”
Regards
VENKAT
Thanks Venkat!
How is our friends, are they referring our Most Useful VBA Tips (70+ Tips, going to be 100+ Tips soon)?
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
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
Done! Added a simple Interactive dashboard.
You can have a look and ask me if you have any questions.
Thanks-PNRao
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
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
Thanks Venkat!
Yes, I will work on the macro and upload it ASAP.
Thanks-PNRao
Hi Sir,
I have sent you a mail in terms of small task(Creating summery table). Pls help me out.
Regards
VENKAT
Thanks Sir for generosity, I am trying to learn VBA Macros and I am finding this site very usefull.
All the best Manish! And thanks for your comments.
Thank-PNRao!
Hi
Thank you very much for these file .
bahman
You are welcome – bahman!
Thanks-PNRao!
i am in recutiment of US IT.Do u have any predefined sheets for that.
Hi Krishna,
I do not have any predefined templates. Please let us know if you want us to prepare now.
Thanks-PNRao!
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
Best web site I’v been ever seen for learning Excel VBA.
Thank You.
Thanks You are most welocm! PNRao!
Hello sir , thanks for all these useful resources.
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
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!
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
in help
Extract data out of 3 columns and put the data into 3 new columns by VBA