Page 1 of 2 12 LastLast
Results 1 to 15 of 26
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Auckland, New Zealand
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel VB Constants (2003)

    Hi John

    This isn't the complete list ?
    How did you get this list., just interested thanks .........

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel VB Constants (2003)

    Hi John

    Nice list, and I think there are many constants that simply aren't referenced in the Help files at all. I'm presuming you extracted these from the Object Browser window. Mind sharing the method you used to achieve this?

    Alan

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

    Re: Excel VB Constants (2003)

    See my response to AlanMiller. Let me know what's missing.
    -John ... I float in liquid gardens
    UTC -7ąDS

  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: Excel VB Constants (2003)

    From the VBE Help. AFAIK it's the complete list of Excel specific constants, it doesn't include the Office-wide Constants, and it doesn't include things such as the Dialogs (I should probably add those - I already have that list). It has always been an annoyance to me that you can't click on a Constant and tree up to the Parent Methods or Properties.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel VB Constants (2003)

    Can you tell us how you found them in VBE Help? I can never find the constants in help (in XL2K).
    Legare Coleman

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

    Re: Excel VB Constants (2003)

    In Excel 2002, you can use the Object Browser to view those constants: press F2 to activate the Object Browser, then type xl into the search box and press Enter.

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel VB Constants (2003)

    But the question is still, "What's the extraction method from the object browser?" Or maybe John had to revert to the manual "read then type" technique... that's so labour-intensive I've forgotten how it's done now. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Alan

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel VB Constants (2003)

    Thanks. I was hoping to find a way to find them in Help that I could use when in the VBE. They are in the object browser, but when you hilite them and press F1 you don't get any help.
    Legare Coleman

  9. #9
    New Lounger
    Join Date
    Jul 2002
    Location
    Auckland, New Zealand
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel VB Constants (2003)

    Hi John, thanks for those useful links.

    OK, I got 167 diff between yours and mine.
    An interesting one that wasn't on my list but on yours was xlXMLData = 47
    Doing a debug print in the imediate Window yielded nothing ?

    I believe ?? the diff are that these Const are Microsoft Excel 5.0, 7.0 const and that your ones
    are from XL97 onwards??

    Any way here is my list.

    Thanks again for your links.

  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: Excel VB Constants (2003)

    You are probably right, and it's also possible that the Excel Help for these items is incorrect, that would not be uncommon for Microsoft (especially whan they incorrectly include Mac items in Windows version help). Do you have any concern if I incorporate your list into my text list and retain the Object headings?
    -John ... I float in liquid gardens
    UTC -7ąDS

  11. #11
    New Lounger
    Join Date
    Jul 2002
    Location
    Auckland, New Zealand
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel VB Constants (2003)

    Absolutely .... go for it......

    and thanks for your list.....it highlighted the fact that they didn't include the prior versions (<Xl97) Const . which means
    they probably won't support ??/ backwards compatibilty for these version. But this is just a guess.

    Thanks again John

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

    Re: Excel VB Constants (2003)

    Legare, I did a little more research, see my now edited <post#=413257>post 413257</post#> on how I found the list in the 2003 VBE help.
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Excel VB Constants (2003)

    Ivan, due to both my lack of time and lack of depth in this stuff, I may need some help; see my PM to you.
    -John ... I float in liquid gardens
    UTC -7ąDS

  14. #14
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel VB Constants (2003)

    Well, right off the bat I guess I am in deep do in XL2K. I don't have the choice of the "Search Help" window, I can only get tht "Office Assistant." Typing "excel intrinsic constants" (intuitively obvious search argument that) gets me a few things, none of which have any resemblance to excel intrinsic constants.
    Legare Coleman

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

    Re: Excel VB Constants (2003 and before)

    Using this kb article , I created this little utility.
    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
  •