View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default ?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