Introduction to VBA Programming

Cheng-Few Lee, John Lee, Jow-Ran Chang and Tzu Tai
Additional contact information
Cheng-Few Lee: Rutgers University, Department of Finance
John Lee: Center for PBBEF Research
Jow-Ran Chang: National Tsing Hua University, Department of Quantitative Finance
Tzu Tai: Mezocliq, LLC

Chapter Chapter 23 in Essentials of Excel, Excel VBA, SAS and Minitab for Statistical and Financial Analyses, 2016, pp 721-762 from Springer

Abstract: Abstract In the previous chapter, we mentioned that VBA was Excel’s programming language. It turns out that VBA is the programming language for all the Microsoft Office applications. Also VBA is becoming the programming language of other popular applications. Some of the other applications that are using VBA as its programming language are Visio and Business Objects. This is very exciting news for people who automate applications. The main advantage is that a person does not have to constantly learn a new language when he or she deals with a new application. Another important advantage of an application adopting VBA as a programming language is it is a language that uses most of the programming concepts that professional programmers use; therefore, VBA is a powerful language. Now, it is easier for an Excel programmer to do Access VBA programming, Word VBA, or even PowerPoint VBA programming. The finance people would say that there is a return in the investment of time in learning VBA.

Keywords: Object model; Object browser; References; Type library; Variables; Data type; Option explicit; Object variables; Functions; If statement; For loop; For Each; While loop; Arrays; Option base; Collections; Byte; Boolean; Integer; Long; Single; Double; Currency; Decimal; Variant; String (search for similar items in EconPapers)
Date: 2016
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:sprchp:978-3-319-38867-0_23

Ordering information: This item can be ordered from
http://www.springer.com/9783319388670

DOI: 10.1007/978-3-319-38867-0_23

Access Statistics for this chapter

More chapters in Springer Books from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().