CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Guest

    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


  2. #2
    Join Date
    May 1999
    Location
    Omika, Japan
    Posts
    729

    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
  •  





Click Here to Expand Forum to Full Width

Featured