|
-
December 2nd, 1999, 12:25 PM
#1
COM Objects, how to get the availble objects
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
-
December 3rd, 1999, 05:27 AM
#2
Re: COM Objects, how to get the availble objects
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|