| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting from "Trial Version" to Excel 2007 | Excel Discussion (Misc queries) | |||
| Environ("USERNAME") | Excel Programming | |||
| environ username vs. application username | Excel Programming | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| Environ("username") | Excel Programming | |||
Linear Mode
