| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
?thisworkbook.VBComponents(5).Type returns 2
Following an upgrade to XPpro, my immediate window more often than not
returns integer codes such as the above, rather than the corresponding type constant (vbext_ct_ClassModule in this case) What have I forgotten to set? Matthew |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
?thisworkbook.VBComponents(5).Type returns 2
I've never seen it return anything but the number.
-- Regards, Tom Ogilvy wrote in message oups.com... Following an upgrade to XPpro, my immediate window more often than not returns integer codes such as the above, rather than the corresponding type constant (vbext_ct_ClassModule in this case) What have I forgotten to set? Matthew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I type in 0 A to a cell it returns 12:00 AM. Need to turn off | Excel Discussion (Misc queries) | |||
| Looking for formula index/match-type that returns an array | Excel Worksheet Functions | |||
| Links between VBComponents and Sheets 3 | Excel Programming | |||
| Links between VBComponents and Sheets 2 | Excel Programming | |||
| Links between VBcomponents and Sheets | Excel Programming | |||
![matthewgdodds@hotmail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
