# Monthly Archives: January 2013

Home/2013/January

## COUNTIF Function in Excel

COUNTIF Function in Excel - formula counts all numbers in a range based on a given criteria. Learn more Formulas, Excel and VBA with examples explained.

By |January 31st, 2013|Excel Formulas|0 Comments

## 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

## SUMIF Function in Excel

SUMIF Function in Excel adds all numbers in a range based on a given criteria. Learn Formulas, Excel and VBA with examples in our free tutorials.

By |January 30th, 2013|Excel Formulas|0 Comments

## Delete Worksheet in Excel VBA

This example will show you how to delete Worksheets from Workbook using Excel VBA. Also find code for stopping the warning message while deleting Worksheets.

By |January 27th, 2013|Excel VBA|6 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

## TRIM Function in Excel

TRIM Function in Excel - formula removes unwanted spaces whether they occur between words or at the beginning or end of a string, except for single spaces between words.

By |January 25th, 2013|Excel Formulas|0 Comments

## CHAR Function in Excel

CHAR Function in Excel returns the last or right most character(or Characters) in a text string. Learn Formulas, Excel and VBA with examples explained.

By |January 18th, 2013|Excel Formulas|0 Comments

## Save Workbook Using Excel VBA to Specific Folder

Solutions: You can use SaveAs method to Save the File Example: ```Sub ExampleToSaveWorkbook() Workbooks.Add 'Saving the Workbook ActiveWorkbook.SaveAs "C:\WorkbookName.xls" 'OR 'ActiveWorkbook.SaveAs Filename:="C:\WorkbookName1.xls" End Sub```

By |January 17th, 2013|Excel VBA|24 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

## RIGHT Function in Excel

RIGHT Function in Excel - formula returns the last or right most character(or Characters) in a text string. Learn Formulas, Excel and VBA with examples.

By |January 15th, 2013|Excel Formulas|0 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

## VBA InputBox Options in Excel to Accept different Formats of Data

InputBox is useful to accept data from the user. it can be either text, number, formula, cell referenc or a logical value.It's not possible with MsgBox.

By |January 13th, 2013|Excel VBA|1 Comment

## 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

## Activate Workbook Or Worksheet in Excel VBA

Activating a Workbook: Syntax: `Workbooks("WorkBook Name").Activate` Note: Workbook name will be your desire workbook name which you want to activate. Ex: If you want to activate a workbook named as “Book1” `Workbooks("Book1").Activate `

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

## 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

## Get Active Workbook or Worksheet Name Path FullName in Excel VBA

When we are working with workbooks and worksheets, some times we may required to access the workbook name or a worksheet name.

###### Solution:
You can get a workbook or a worksheet names by using Name property of the workbook or worksheet.

By |January 10th, 2013|Excel VBA|1 Comment

## LEFT Function in Excel

LEFT Function in Excel - formula returns the first or left most character(or Characters) in a text string. Learn Formulas, Excel and VBA with examples .

By |January 10th, 2013|Excel Formulas|0 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
##### Solution:
We can use Workbook_Open() method or Auto_Open() method to achieve this.

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

## Excel VBA Downloads

You can download our free excel templates, Dashboards, VBA example files and Tools, by exploring this you will get different ideas to do more with your data and presentation, you may find some of these codes are useful to include in your automation.

Visit Downloads Page

By |January 6th, 2013|Excel VBA|41 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

vba excel combo boxbeginners guide to vbamicrosoft excel vba referencesumif excel 2007access vba sql updatedbms interview questions and answers pdf free downloadhow to use vlookup 2010remove password from excel 2010 workbookms access interview questions and answers free pdfexcel copy cell to another sheetexcel vba msgbox inputmacro in excel with exampleusing functions in vbaconvert excel column width to inchesadvanced pivot table techniquesexcel 2007 match functionadding columns in exceltask scheduler excel templateexcel workbook vs worksheetcopy excel worksheet to another workbookprotected worksheetvba debugaccess vba case statementexcel copy row to another sheetend loop vbaexcel consolidate toolpaste vba excelvba structureado connectionrows vba excelspeed up vbaexcel formulas to find duplicatesexcel macro cell valuehow to remove protection from excel sheet 2007how to create macro button in excelsql in sasvba source codeinsert macro exceluserform in excelexcel vba userform positionsoftware costing templatevba reference guideexcel vba messagetypes of errors in ms excelvba for excel tutorialisna in excelcreate object in vbahow to do pivot table in excel 2010vba is nullexcel checkbox in cellobjfso.opentextfileexcel tutorial vlookupvba isblankcreate excel macroclustered column chart excel 2013ddl commands sqlhow to use vlookup in excel 2010 step by stepadvance excel tutorialinstr function exceltask planner templatedelete file vb6find duplicate rows in excelexcel macro to insert rowscell height excelremove sheet protection excelarrays in vbavbyesnoexcel colour indexcheckbox syntaxexcel iferror formulahow to understand excel formulashow to highlight columns in excelexcel vba adodb connection string sql serveriferror excel functionexcel change columns to rowsvba programming guideexcel macro query