|
-
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
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
|