Visual Basic 2008 Programming: Business Applications with a Design Perspective
Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9
Chapter 10 Chapter 11 Chapter 12 Chapter 13 Chapter 14 Appendix A Appendix B Appendix C Home
Last change: February 13 2016 18:48:19.

 Chapter in PDF

Table of Contents

Chapter 14 Beyond the Core
Last change: February 13 2016 18:47:53.

14.2 Extending the Power of VB

This section discusses how you can extend VB’s power by using other existing software systems. Microsoft Office Excel and Word are used to demonstrate the possibilities. Both Excel and Word are widely used in various business applications. The focus of this section is not on how to program these applications but how to connect them from VB so that their capabilities can be tapped.

The first subsection deals with Excel, where a worksheet has been developed to compute the internal rate of return for any investment project. A simple VB program is written to enter the cash flow for an investment project onto the worksheet and obtain the result. The second subsection shows how to retrieve text from a Word document, manipulate the text to generate another document, and save the results.

Last change: February 13 2016 18:47:55.
  1. Using the Windows Registry for application settings
  2. Using the My.Settings Object
  3. Additional Remarks
  • 14.2 Extending the Power of VB
    1. Using MS Excel in VB
    2. Using MS Word in VB
    3. <<PreviousNext>>