Chapter 8. Programming Excel

     

In this chapter

  • Working with Excel's Application object.

  • Accessing worksheet functions in your code.

  • Running a procedure at a certain time or when the user presses a certain key.

  • Manipulating Workbook objects in your VBA code.

  • Dealing with Worksheet objects.

  • Specifying and working with Range objects.

If you're using VBA in Excel, most of your procedures will eventually do something to the Excel environment. They might open a workbook, rename a worksheet, select a cell or range, enter a formula, or even set some of Excel's options. Therefore, knowing how VBA interacts with Excel is crucial if you ever hope to write useful routines. This chapter looks closely at that interaction. You learn how to work with all the most common Excel objects, including the Workboo k, Worksheet , and Range objects.



Absolute Beginner's Guide to VBA
Absolute Beginners Guide to VBA
ISBN: 0789730766
EAN: 2147483647
Year: 2003
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net