Can't find the ClassId of the VBIDE ?

[Jaafar Tribak]

Hi dear board members.- I've looked in the Registry but cannot find the entry for the 128 bit CLSID of the VBIDE COM object. Does anybody know it ?

The one for the Excel application is located in the reg Key: <TABLE style="WIDTH: 60pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=80 border=0 x:str><COLGROUP><COL style="WIDTH: 60pt" width=80><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=80 height=17>HKEY_CLASSES_ROOT\Excel.Application\CLSID</TD></TR></TBODY></TABLE>
and returns the string :
{00024500-0000-0000-C000-000000000046}

Which is indeed the correct CLSID for the excel application Class (COM object)


The closest i got in relation to the VBIDE is the following

Registry Key :<TABLE style="WIDTH: 60pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=80 border=0 x:str><COLGROUP><COL style="WIDTH: 60pt" width=80><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=80 height=17>HKEY_CLASSES_ROOT\Excel.VBAModule\CLSID</TD></TR></TBODY></TABLE>
CLSID:
{00020820-0000-0000-C000-000000000046}

Does anybody know how to retrieve the VBIDE CLSID or what object the above CLSID refers to ?

Regards.

 

[RoryA]

I think that's the CLSID for Excel.Sheet.8

 

[Jaafar Tribak]

I think that's the CLSID for Excel.Sheet.8

Thanks and sorry for the late response.

Excel.Sheet.8 refers to the XLB ClassID. Double chexked in the Reg editor too .

Regards.