Monthly Archives: January 2013


Hide UnHide Worksheets in Excel VBA

VBA hide unhide worksheets example macro macro helps when we have many worksheets in a workbook and you want to show only specific worksheets to the user. You can hide unhide worksheets using Excel VBA. For Example you may be developing a tracker for different departments in an organization. Like HR, Admin, Finance, etc..., all

By |January 30th, 2013|Excel VBA|32 Comments

Introduction to VBA

VBA is a common language for all MS Office Tools (Excel, Word, PowerPoint,Outlook,Access), if you learn Excel VBA, you can able to automate any MS Office Tool, the only change is object model.

In this session:
  • Introduction to VBA
  • Why should I learn VBA?
  • What things can we do using VBA?
  • How many ways we can automate tasks using VBA?

By |January 27th, 2013|Excel VBA|7 Comments

Open and Close Excel Workbook using VBA

Solution: You can use the Open method to Open an Existing Workbook Example: The following code create a new workbook and save in the C drive Sub ExampleOpenAnExistingWorkbook() Workbooks.Open "C:\WorkbookName.xls" 'OR 'Workbooks.Open Filename:="C:\WorkbookName1.xls" End Sub

By |January 15th, 2013|Excel VBA|14 Comments

Create New Workbook in Excel VBA

Solution: You can use Add method to create new workbook Example: The following code create a new workbook and save in the C drive Sub ExampleAddNewWorkbook() 'Adding New Workbook Workbooks.Add 'Saving the Workbook ActiveWorkbook.SaveAs "C:\WorkbookName.xls" 'OR 'ActiveWorkbook.SaveAs Filename:="C:\WorkbookName1.xls" End Sub

By |January 13th, 2013|Excel VBA|2 Comments

SQL Operators

SQL Operators helps us to write expressions in SQL queries, We use Arithmetic Operators, Comparison Operators, Logical Operators and Wildcard Operators while extracting and summarizing the data for analysis.

By |January 13th, 2013|SQL|1 Comment

Advanced Excel VBA Programming

Advanced VBA Programming helps you to develop user friendly applications.Learn by following our easy to follow step by step tutorials and automate any task.

In this Section:
  • Advanced VBA Programming - Learning Outcomes.
  • Learning Path (TOC): Start Learning Advanced VBA.
  • Are you feeling these topics are more advanced? Don't panic!
  • Are you novice to Excel? Start Learning from the Basics!
  • I have completed Advanced VBA, What Next?

By |January 12th, 2013|Excel VBA|14 Comments

Run a Macro Automatically on Opening Excel Workbook

Sometimes you may want to run a particular macro automatically while opening the excel file.

Example Cases:
  • You may want to show a welcome message to the user
  • You may want to run some sarting scripts before while opening the workbook
  • You may want to fill some data while opening the workbook
  • You may want to activate a particular sheet while opening the workbook
  • You may want to show a user form while opening the workbook
We can use Workbook_Open() method or Auto_Open() method to achieve this.

By |January 8th, 2013|Excel VBA|10 Comments

Excel VBA Programming

Excel VBA Programming helps to learn from the basics to write your own VBA programs like sub routines, functions to automate your daily tasks. By end of this session you will be able to write the procedures and functions to automate tasks and you will find significant time saving while working with your projects. Topics

By |January 5th, 2013|Excel VBA|0 Comments

Related pages

excel iserrsimple excel macros exampleshow to shade cells in excelexcel cell blankexcel vba userform code examplesunprotect a workbook without passwordexcel iferror vlookupmacro commands in excelexcel lookup function exampleshow do you check for duplicates in excelinsert a row above the selected rowsave xlsm as xlsx vbahow to unhide all columns in excelunlock excel spreadsheet 2007datevalue functionvba defineexcel if statement stringlookup excelhide columns vbamerge excel worksheets without copying and pastingvba sample projectsactivesheet listobjectslistbox columnworksheetfunctionvba interview questionsadvanced vba excelexcel shortcut keys insert rowdeleting rows in excelado connection string sql server 2008excel macro unhide all sheetsuseful excel spreadsheetsexcel if statement formatfunction in excel vbaunshare a workbookexcel how to use sumifvba while loop examplehow to make pivot table in excel 2010simple vbscript examplerunning macro in excelsample project timeline excelexcel vba protect workbookexcel vba save as xlsxgetopenfilename vba excelpivot chart in excel 2007excel change columns to rowsvba delete entire rowdeveloper tab in excel 2013math and trig functions in excelvba 2007vba selection endif vlookup exampleif functions in excel 2010powerpivot excel 2010 examplesremove password excel workbookprovider msdasqlredim array vbadeclaring variables in vbavba excel examples with codesvba yes no boxcreating vba macros in excel 2010base sas tutorial for beginnerscount vbaworkbook close vbamacro security excel 2010vlookup reverseproject estimation excel templatevba application inputboxweekly gantt chart templateexcel vba forms tutorialexcell checkboxsample project timeline excelvba for excel pdfexcel 2007 userformremove duplicate cells excelcopy folder vbscripthow to learn excel vba