none
Mehtods Properties and Events in Object Browser and References RRS feed

  • Question

  • Hello Friends
    1. I started learning about VBA using Excel VBA help file. There I could find examples related to each property, method, and event. Same thing I found with Outlook, Word, Powerpoint, Access, but when I tried for Internet Explorere I could not find such help file. On Microsoft site and in visual studio I can browse object browser for Internet Explorer but can't find examples related to them (specially for offline view
    2. Also in Add reference options I can see long lists of .com objects. How can I know which .com object is for what us, as some object names are uncomprehensible. Thanking you for your time and consideration.
    3. As I was guided here from another thread, if you wanna understand my problem fully, then please visit : http://social.technet.microsoft.com/Forums/en-US/ITCG/thread/8f27c770-2f99-41cf-85c2-be942ff52034/#9908d260-91d3-4371-b498-df6305af75fe
    Thanking you for time and consideration.
    <input id="8f27c770-2f99-41cf-85c2-be942ff52034_attachments" type="hidden" />
    Saturday, February 4, 2012 4:11 AM

Answers

  • Hello again Ajay! ;-))

    To understand COM a bit more read trough this WIKIpedia Article:
    http://en.wikipedia.org/wiki/Component_Object_Model
    and
    http://technet.microsoft.com/en-us/library/ee198909.aspx

    COM is a umbrella term !
    COM is written COM or DCOM not .com !

    The List of avaiable COM objects you can refer to, is on each computer different!
    Why?
    Some COM dlls are shipped with Windows and you can expect that they are allways there!
    Most COM objects are installed after Windows!
    I you want to deal with PDF stuff, there is no COM for it on a naked Windows!
    If you Install the Adobe Acrobat reader you can use his COM objects he offers.

    For the Documentation of the COM Objects the Vendors of the COM Objects are responsible!
    For the documentation of the COM interface of Adobe Acrobat, you have to ask/search Adobe!

    If your Progamm / VBA refers to the Adobe COM Objects and you give your Programm to a friend and
    his Computer dont have installed Adobe Acrobat, your Programm will fail!!!!
    The reference cant find the DLLs!
    This is sometimes even the Case if you have Office Version 10 and your Friend have Office Version 14 !!
    This might even fail!
    see: http://technet.microsoft.com/en-us/library/ee198863.aspx

    Most COM objects are never Documentet, because Documentation costs Money and COM objects are often dealed as Secrets!
    Even Microsoft do so!
    So you have  often to reverse engeneer COM Objects, to see wich Propertys and Methods they offer!
    You can use the Object browser wich is build into Microsoft Visual Studio (Basic) .Net Express Edition, to explore the COM Universe.

    Visual Basic and Objects (COM)
    http://www.garybeene.com/vb/tut-obj.htm

    COM and AutoIt (but general Useful)
    http://www.autoitscript.com/autoit3/docs/intro/ComRef.htm

    If you search for Documentation, for a specific COM Object, you have to use search engines!
    There you can use the Term Automating !
    eg.: AUTOMATING INTERNET EXPLORER (do it now in Google!)
    you will find this: http://msdn.microsoft.com/en-us/library/ie/aa752084(v=vs.85).aspx

    if you know that it is a Microsoft COM Object you can use the Term MSDN in your searches!

    If you know the DLL or EXE name you can use this Name with the term Documentation.
    eg.: SHDocVw.dll documentation MSDN
    You will find this: http://msdn.microsoft.com/en-us/library/ie/aa741312(v=vs.85).aspx

    So i think it is clear now!? If you want to know what the references are doing, you have to put the reference Name from the list into a search engine. If you are in luck you will find documentation and know how.

    If you have a specific Problem and you dont know how to solve with VBA?
    That are Forums for ! ;-)) You will be Pointed to the right COM Object if your Question is clear defined!
    So think of: How to ask questions right/best and how can i get best search results!

    TIPP:
    In Forums it is best, to ask one Question in one Post ;-)

    Finally i do a harder search to find COM Browsers who examins then OBjects.
    Here is the List I have found:

    Microsoft Visual Studio (express) Object Browser (as mentioned above)

    Microsoft old OLE/COM Browser (out-dated?):
    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7007

    ActiveXHelper v1.12 - View ActiveX Information
    http://www.nirsoft.net/utils/axhelper.html

    Object Browser
    http://www.brothersoft.com/objectbrowser-191883.html

    Hope that helps....


    Please click “Mark as Answer” if my post answers your question and click "Vote as Help" if my Post helps you.
    Bitte markiere hilfreiche Beiträge von mir als "Hilfreich" und Beiträge die deine Frage ganz oder teilweise beantwortet haben als "Antwort". Das wäre Nett :-))
    My PowerShell Blog http://www.admin-source.info
    [string](0..21|%{[char][int]([int]("{0:d}" -f 0x28)+('755964655967-86965747271757624-8796158066061').substring(($_*2),2))})-replace" "




    • Marked as answer by Ajay Check Saturday, February 4, 2012 2:42 PM
    • Edited by Peter Kriegel Sunday, February 5, 2012 8:28 AM
    Saturday, February 4, 2012 8:23 AM

All replies

  • Hello again Ajay! ;-))

    To understand COM a bit more read trough this WIKIpedia Article:
    http://en.wikipedia.org/wiki/Component_Object_Model
    and
    http://technet.microsoft.com/en-us/library/ee198909.aspx

    COM is a umbrella term !
    COM is written COM or DCOM not .com !

    The List of avaiable COM objects you can refer to, is on each computer different!
    Why?
    Some COM dlls are shipped with Windows and you can expect that they are allways there!
    Most COM objects are installed after Windows!
    I you want to deal with PDF stuff, there is no COM for it on a naked Windows!
    If you Install the Adobe Acrobat reader you can use his COM objects he offers.

    For the Documentation of the COM Objects the Vendors of the COM Objects are responsible!
    For the documentation of the COM interface of Adobe Acrobat, you have to ask/search Adobe!

    If your Progamm / VBA refers to the Adobe COM Objects and you give your Programm to a friend and
    his Computer dont have installed Adobe Acrobat, your Programm will fail!!!!
    The reference cant find the DLLs!
    This is sometimes even the Case if you have Office Version 10 and your Friend have Office Version 14 !!
    This might even fail!
    see: http://technet.microsoft.com/en-us/library/ee198863.aspx

    Most COM objects are never Documentet, because Documentation costs Money and COM objects are often dealed as Secrets!
    Even Microsoft do so!
    So you have  often to reverse engeneer COM Objects, to see wich Propertys and Methods they offer!
    You can use the Object browser wich is build into Microsoft Visual Studio (Basic) .Net Express Edition, to explore the COM Universe.

    Visual Basic and Objects (COM)
    http://www.garybeene.com/vb/tut-obj.htm

    COM and AutoIt (but general Useful)
    http://www.autoitscript.com/autoit3/docs/intro/ComRef.htm

    If you search for Documentation, for a specific COM Object, you have to use search engines!
    There you can use the Term Automating !
    eg.: AUTOMATING INTERNET EXPLORER (do it now in Google!)
    you will find this: http://msdn.microsoft.com/en-us/library/ie/aa752084(v=vs.85).aspx

    if you know that it is a Microsoft COM Object you can use the Term MSDN in your searches!

    If you know the DLL or EXE name you can use this Name with the term Documentation.
    eg.: SHDocVw.dll documentation MSDN
    You will find this: http://msdn.microsoft.com/en-us/library/ie/aa741312(v=vs.85).aspx

    So i think it is clear now!? If you want to know what the references are doing, you have to put the reference Name from the list into a search engine. If you are in luck you will find documentation and know how.

    If you have a specific Problem and you dont know how to solve with VBA?
    That are Forums for ! ;-)) You will be Pointed to the right COM Object if your Question is clear defined!
    So think of: How to ask questions right/best and how can i get best search results!

    TIPP:
    In Forums it is best, to ask one Question in one Post ;-)

    Finally i do a harder search to find COM Browsers who examins then OBjects.
    Here is the List I have found:

    Microsoft Visual Studio (express) Object Browser (as mentioned above)

    Microsoft old OLE/COM Browser (out-dated?):
    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7007

    ActiveXHelper v1.12 - View ActiveX Information
    http://www.nirsoft.net/utils/axhelper.html

    Object Browser
    http://www.brothersoft.com/objectbrowser-191883.html

    Hope that helps....


    Please click “Mark as Answer” if my post answers your question and click "Vote as Help" if my Post helps you.
    Bitte markiere hilfreiche Beiträge von mir als "Hilfreich" und Beiträge die deine Frage ganz oder teilweise beantwortet haben als "Antwort". Das wäre Nett :-))
    My PowerShell Blog http://www.admin-source.info
    [string](0..21|%{[char][int]([int]("{0:d}" -f 0x28)+('755964655967-86965747271757624-8796158066061').substring(($_*2),2))})-replace" "




    • Marked as answer by Ajay Check Saturday, February 4, 2012 2:42 PM
    • Edited by Peter Kriegel Sunday, February 5, 2012 8:28 AM
    Saturday, February 4, 2012 8:23 AM
  • Hi, Peter Kriegel !

    1. I have read and understood only below link
    : http://en.wikipedia.org/wiki/Component_Object_Model .
    Yet I have to read and understand others also. But now my doubts are fully resolved.

    2. Previously I could not find proper path, to understand VBA and VBScript, but now you have made paths clear.

    3. As you and Bigteddy suggested, would be learning WSH also, because now I have got some idea about scripting fundamentals.

    4. eg.: AUTOMATING INTERNET EXPLORER (do it now in Google!)
    and
    http://msdn.microsoft.com/en-us/library/ie/aa741312v=vs.85).aspx#com_based_architecture

    Yes, I did check them, and got informative results.

     5. Being new to Technet forum and desperate to find solution, made me to hastily post question in more than one forum. Would be careful next time. . .

    6. And as you said : Hope that helps....

    No . . no . . it did more than help. ;-) . Actually above explanation has given me confidence to explore VB further.

    7. Would be always grateful to you for this, kind support.

    With many thanks and wishes : Ajay Check
    • Edited by Ajay Check Saturday, February 4, 2012 2:51 PM
    Saturday, February 4, 2012 2:43 PM
  • Live long and prosper !
    Please click “Mark as Answer” if my post answers your question and click Vote as Help if my Post helps you.
    Bitte markiere hilfreiche Beiträge von mir als Hilfreich und Beiträge die deine Frage ganz oder teilweise beantwortet haben als Antwort.
    My PowerShell Blog http://www.admin-source.info
    [string](0..21|%{[char][int]([int]("{0:d}" -f 0x28)+('755964655967-86965747271757624-8796158066061').substring(($_*2),2))})-replace" "
    Saturday, February 4, 2012 4:06 PM