<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN' 'http://www.w3.org/TR/html4/loose.dtd'>; <html><head><title>Article Directory Online : Free Online Article Submission - Articleonlinedirectory | Understanding Object Methods In Excel Vba</title></head><body><h3>Understanding Object Methods In Excel Vba</h3><br /><br />By: <br /><br /><p>Automating Microsoft Excel with Visual Basic for Applications (VBA) involves the programmatic manipulation of the objects inherent in Excel, such as worksheets, charts and pivot tables. In VBA, each of these objects has properties and methods which can be used to manipulate the object and make it do what you need it to. Properties are the attributes or characteristics that the object possesses, whereas methods are actions associated with the object. For example, a workbook has a "name" property and an "open" method.<br /> <br /> Methods are slightly more complex than properties in that they normally, though not always, require amplification in order to get a particular object to perform a particular action. This amplification is provided through the arguments which the programmer has to supply when using the method. Thus, in order to exit Excel altogether, we would use the "quit" method of the "Application" object, thus: "Application.Quit" without supply any arguments.<br /> <br /> However, if we want to open a workbook, we need to supply at least one parameter: a string specifying the workbook to be opened. As you write your code, Excel will furnish a useful prompt: having entered the method, if you type an opening parenthesis, a "QuickInfo" tool tip will appear with a list of the parameters required by the method. This facility is much the same as the display of parameters when you enter a function in Excel.<br /> <br /> Any arguments which are displayed in square brackets are optional while those not in square brackets are obligatory. Thus, for example, when using the "Open" method of the "Workbook" object, the "Filename" parameter is obligatory while the "ReadOnly" parameter is optional.<br /> <br /> The "QuickInfo" tool tip supplies a list of every parameter, separated by commas, which the method can accept in the order that they must be supplied. If you do not wish to supply a given (optional) parameter, then you must still insert a comma to mark the position of the omitted argument. Thus, for example, if you wanted to use the "Open" method of the "Workbook" object and supply the "Filename" and the "ReadOnly" parameters, you would type "Workbooks.Open("c:reportsmain.xlsx", , True)". Since the "ReadOnly" parameter is the third, a comma is inserted to mark the position of the missing second parameter.<br /> <br /> VBA offers a very useful alternative method of entering arguments. You can enter the name of each parameter followed by ":=". Using this technique, the order of parameters becomes unimportant and no reference has to be made to omitted parameters. Thus, in the example above, we could type "Workbooks.Open(FilePath:="c:reportsmain.xlsx", ReadOnly:=True)".</p> <br /><br /><b>Author Resource:-></b> You can get up to date information on Excel VBA training courses, visit <a href=http://www.macresource.co.uk/dreamweaver_training/?p=626>Macresource Computer Training</a>, an independent computer training company offering <a href=http://www.macresource.co.uk/fasttrackspecials/msexcel.html>Excel VBA training courses</a> in London and throughout the UK.<br /><br /><b>Article From</b> <a href='http://www.articleonlinedirectory.com/'>Article Directory Online : Free Online Article Submission - Articleonlinedirectory</a><br /></body></html>
