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