barcode generator in c# windows application free Introducing the Application Object in Visual C#.NET

Make Denso QR Bar Code in Visual C#.NET Introducing the Application Object

The Application object is the highest object within the Microsoft Excel Object Model. The Application object contains all of the properties and methods to fully manipulate the Excel application, along with the objects that represent individual workbooks and the data they contain. Because it is the topmost object within the object model, logically you would need to begin all references with the Application object. To refer to the first cell in a worksheet (A1), you would need to start at the Application object, go to the Worksheet object, and then select the Cell object. To set the first cell equal to 100, the VBA code would be as follows:

Application.Workbooks(1).Worksheets(1).Cells(1,1) = 100

Lengthy sequences in dot notation are cumbersome to use, so the Excel programmers did expose some of the more common objects directly, such as workbooks, worksheets, and cells, without the code having to go through the Application object. Care must be taken, especially when working with cells directly, that you have selected the proper workbook and worksheet. If you re sure you have selected the proper workbook and worksheet, such as by using the Worksheet object s Activate method described in the next section of this chapter, you could abbreviate the previous command to Cells(1,1) = 100.

Working with the Application object will usually involve reading or setting one of its many properties. The Application object contains more than 170 properties that let you control every aspect of the Excel application. From workbooks and worksheets to columns and rows, the Application object provides access to practically every element of Excel and Excel workbooks. With so many properties, it is impossible to know every available property, and it s not nec essary to do so. There is a short list of about 10 properties that are the most common prop erties and should be learned to fully work with Excel using VBA. The other properties can be learned as you need them. The important thing is to know that they are there for future exploration.

6

The Application Object The following Application object properties are the most used:

ActiveCell ActiveChart ActiveSheet ActiveWindow ActiveWorkbook RangeSelection Selection ScreenUpdating StatusBar ThisWorkbook

You can get information on every element of the Excel object model in the Visual Basic Editor help system by typing object model in the Ask A Question box and viewing the Microsoft Excel Object Model help topic.

The short list of Application properties contains the most common objects that are used within Excel. Most have been exposed directly by the Excel programming team so that an explicit reference to the application object isn t needed. These properties are described in the following sections in alphabetical order.

The ActiveCell property is exactly what its name implies: a reference to the currently active cell on the active work sheet on the active workbook. When called, the ActiveCell property returns a Range object that can be used to set the value or formula of the cell along with any formatting changes you might want to make (font style, borders, format of numbers, and so on). The following example uses the CellBorder procedure to examine the value of a cell and change the border around the cell if it has a value between 500 and 1000. The ApplyBorders procedure loops through all of the specified data cells within the Y2001ByMonth.xls workbook, shown in Figure 6-2, and then calls the CellBorder procedure for each cell.

Sub ApplyBorders() Dim MyCell As Range For Each MyCell In _ ActiveSheet.Range(D6:O36").Cells MyCell.Select If ActiveCell > 500 And ActiveCell < 1000 Then With ActiveCell.Borders .Weight = xlThick .Color = vbBlue End With End If Next MyCell End Sub