Converting Environ("username") from 2003 to 2007

[Chilidog]

I'm in the process of migrating to MS Office 2007. Problem is once I convert
some code items that work in 2003 seem bomb out in 2007. Specifically, the
Environ("username") function. Does anyone know how this converted in 2007?
Thanks in advance for any help, it is greatly appreciated.

Scott

 

[Barb Reinhardt]

IIRC, I had to enter USERNAME in upper case.

 

[Barb Reinhardt]

Ignore the previous response. It works either way for me.

 

[Chilidog]

Is this associated with a particular reference that needs to be added in the
VB design window?

 

[Mike H]

Hi,

That hasn't changed

MsgBox Environ("Username")

works fine

Mike

 

[Gord Dibben]

Environ("username") returns the Windows login username.

Might be the problem lies with the OS and method of login??

I run only WindowsXP with multiple users so can't test.


Gord Dibben MS Excel MVP