Click to See Complete Forum and Search --> : COM Objects, how to get the availble objects


December 2nd, 1999, 11:25 AM
Hi
I want to access the Com Objects for scripting. For some reason I cannot find the list of available objects in VB. I have used them once before using the XL workbook object. Could any one please tell me where to find these objects on VB'S toolbar?? They are staring me in the face and I just cannot find them..
Any help would be much appreciated..

Simple Example script using basic XL WB Object

set xl = CreateObject("xl.Application")
set wb = xl.workbooks.add
set ws = wb.sheets(1)

xl.visible = true
ws.range("a1") = 10
ws.range("a2") = 20
ws.range("a3") = "sum(a1:a2)"


Set XL = Create

Ravi Kiran
December 3rd, 1999, 04:27 AM
If you are looking for references, goto "Project"->"References" menu and in the enusing dialog, select the Excel object, and when you click the object Browser in the tool bar, you should be able to see the menthods and properties

RK