Environ("username") - compile error Excel 2010

[MerkDog]

Hi,

The following code used to work fine for me in Excel 2003:

MsgBox Environ("username")

In 2010, I get a compile error: "cannot find project or library". I get the same error on trying to use the Chr function, which makes me think it must be something obvious...but I can't figure it out.

Thanks
MerkDog

Excel 2010, Windows XP

 

[VoG]

Greg,
In 2010 you can just use:

Sub foo()
    UserForm1.Show VBA.[__MIDL___MIDL_itf_m_0001_0016_0001].vbModal
End Sub

I'm clearly out of my depth

 

[shg]

UserForm1.Show VBA.[__MIDL___MIDL_itf_m_0001_0016_0001].vbModal

Well, of course -- who wouldn't know that?

 

[RoryA]

Beats me...

 

[Jaafar Tribak]

Greg,
In 2010 you can of course just use:

Sub foo()
    UserForm1.Show VBA.[__MIDL___MIDL_itf_m_0001_0016_0001].vbModal
End Sub

What ? !!!!

 

[Greg Truby]

Rory,

(a) How did you suss out the .[__MIDL___MIDL_itf_m_0001_0016_0001]. bit? "__MIDL___MIDL_itf_m_0001_0016_0001" returns zero hits on Google, so you didn't find it on the internet.

and (b) alas, this is not backwards compatible with Excel 2007.

 

[RoryA]

Oh, I know it's not backwards compatible - you'd have to wrap it in an #If VBA7 block.

Does no-one read the Object Browser anymore? Deary me...

 

[Jaafar Tribak]

Rory,

(a) How did you suss out the .[__MIDL___MIDL_itf_m_0001_0016_0001]. bit? "__MIDL___MIDL_itf_m_0001_0016_0001" returns zero hits on Google, so you didn't find it on the internet.

and (b) alas, this is not backwards compatible with Excel 2007.

Isn't that a hidden Property ?

 

[Greg Truby]

Isn't that a hidden Property ?

I tried ticking the Show Hidden Members option when reviewing the OB before posting and didn't see it. Where the Dickens are you looking, Rory?

 

[RoryA]

Select vbModal in the OB and you will see it's a member of VBA.__MIDL___MIDL_itf_m_0001_0016_0001

 

[Greg Truby]

Select vbModal in the OB and you will see it's a member of VBA.__MIDL___MIDL_itf_m_0001_0016_0001

DOH!


I had also looked there in 2007 OB, but failed to do it again in 2010 OB. Sheesh! And yes, I oughtter have mentioned the whole #IF VBA7 as a workaround, shame on me.