Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Listing an Object's Properties and Methods (Excel 2000 & up)

    If you do some VBA programming regularly, you'll be acquainted with the Object browser, which neatly shows you all objects, properties and methods belonging to any object in Excel (or any other library you have referenced in your VBA project).
    Whilst this is a tremendous tool to look for information on just a couple of properties I find it not very handy when you e.g. need to get all of an objects properties into your VBA code.
    So because I like a challenge I decided to build my own object browser, which is shown to you here .

    It looks like this:
    Attached Images Attached Images
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    Very nice <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

    StuartR

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    Tlbinf32.dll is part of Visual Studio 6 / VB6, so it is not necessarily present on all PCs. It isn't on my home PC, for example. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>
    It's not hard to find sites that make it available for download, but I don't know whether that is legal.
    Great idea, though!

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    How adaptable will this be to other apps?

    I look for MS to steal your idea within a couple of office version iterations.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15>, one site states that it is redistributable. (So I nabbed it.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    <P ID="edit" class=small>(Edited by JohnBF on 14-May-07 07:58. )</P>On first run, in ufObjeBrowser, Private Sub AddObjectToTree(...) I get an error "object or library not found" on tvwChild; I guess for the reason Hans explained. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

    Edit: yep, tlbinf32.dll must be installed and registered, which isn't the case on many machines. Jan Karel, you may want to check for yourself that it is redistributable.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    You can get it (legally!) here: http://support.microsoft.com/kb/224331
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    Thanks!
    -John ... I float in liquid gardens
    UTC -7ąDS

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    Sorry, that is just the help file (tlbinf32.chm), it doesn't include the .dll. (I had already tried that route.)

  10. #10
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    -John ... I float in liquid gardens
    UTC -7ąDS

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> Me too... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    I have updated my site to include the download.
    Would be nice to know if this IS negal though.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    I have updated my site to include the download.
    Would be nice to know if this IS legal though.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  14. #14
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    Does your VS6/VB6 EULA list what is redistributable?
    -John ... I float in liquid gardens
    UTC -7ąDS

  15. #15
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listing an Object's Properties and Methods (Excel 2000 & up)

    That is the fun part, I HAVE NO VB6, nor VS.NET on this system. Maybe I have the tlb because I have Office XP pro (or maybe I even downloaded the tlb my self too, I cannot remember)?

    I might ask MSFT about this.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •