RIGHT Function in Excel
PNRao2022-06-17T03:54:20+05:30RIGHT Function in Excel - formula returns the last or right most character(or Characters) in a text string. Learn Formulas, Excel and VBA with examples.
Open and Close Excel Workbook using VBA
PNRao2022-06-17T03:52:53+05:30Solution: 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
SQL Operators
PNRao2013-01-13T00:00:00+05:30SQL 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.
Create New Workbook in Excel VBA
PNRao2022-06-17T03:52:52+05:30Solution: 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
VBA InputBox Options in Excel to Accept different Formats of Data
PNRao2022-06-17T03:52:52+05:30InputBox 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.
Activate Workbook Or Worksheet in Excel VBA
PNRao2022-06-17T03:52:45+05:30Activating 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
Advanced Excel VBA Programming
PNRao2022-06-17T03:52:29+05:30
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?
- 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?
LEFT Function in Excel
PNRao2022-06-17T03:54:17+05:30LEFT Function in Excel - formula returns the first or left most character(or Characters) in a text string. Learn Formulas, Excel and VBA with examples .
Get Active Workbook or Worksheet Name Path FullName in Excel VBA
PNRao2022-06-17T03:52:44+05:30When 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.
Run a Macro Automatically on Opening Excel Workbook
PNRao2022-06-17T03:52:36+05:30Sometimes 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.
Excel VBA Downloads
PNRao2022-06-17T03:52:32+05:30You 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.
Excel VBA Programming
PNRao2013-01-05T00:00:00+05:30Excel VBA Programming helps to learn from the basics to [...]