Converting Environ("username") from 2003 to 2007
 

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

Converting Environ("username") from 2003 to 2007
 

IIRC, I had to enter USERNAME in upper case.

"Chilidog" wrote:

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

Converting Environ("username") from 2003 to 2007
 

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

"Chilidog" wrote:

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

Converting Environ("username") from 2003 to 2007
 

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

"Barb Reinhardt" wrote:

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

"Chilidog" wrote:

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

Converting Environ("username") from 2003 to 2007
 

Hi,

That hasn't changed

MsgBox Environ("Username")

works fine

Mike

"Chilidog" wrote:

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

Converting Environ("username") from 2003 to 2007
 

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

On Thu, 17 Sep 2009 06:42:09 -0700, Chilidog
wrote:

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

"Barb Reinhardt" wrote:

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

"Chilidog" wrote:

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