Late Binding

User avatar
Don Wells
5StarLounger
Posts: 689
Joined: 27 Jan 2010, 16:45
Location: Ottawa, Ontario, Canada

Late Binding

Post by Don Wells »

    In converting from early to late binding it is necessary to change all built-in constants to their intrinsic values. MS used to provide the data facilitating this task on their website but I am unable to locate it now. I discovered that the intrinsic value for olFolderCalendar is 9 using the "Suck It And See" approach. Thank goodness that the value wasn't in the neighbourhood of 4000.

    Can anyone provide a viable link to these data?

T.I.A.
Regards
Don

User avatar
StuartR
Administrator
Posts: 12601
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Late Binding

Post by StuartR »

In the VBE environment, you can View the Object Browser and then search for the constant you need
olFolderCalendars.png
You do not have the required permissions to view the files attached to this post.
StuartR


User avatar
Don Wells
5StarLounger
Posts: 689
Joined: 27 Jan 2010, 16:45
Location: Ottawa, Ontario, Canada

Re: Late Binding

Post by Don Wells »

Thank you Stuart

That's so much easier than going to a web page and looking it up.
Regards
Don

User avatar
Jan Karel Pieterse
Microsoft MVP
Posts: 656
Joined: 24 Jan 2010, 17:51
Status: Microsoft MVP
Location: Weert, The Netherlands

Re: Late Binding

Post by Jan Karel Pieterse »

You can also use the debug window and type
?TheConstant
followed by an enter.
Regards,

Jan Karel Pieterse
Excel MVP jkp-ads.com