Environ("Username") with Windows7 64bit
in [Programming]
|
Prev: Export multiple Excel sheets to a single text file
Next: Wanted: ? UnknownFunction("vbOK") returns 1 in VBE Immediate wind
From: Jamen Lone on 13 Feb 2010 04:15 Hi all, I'm using XL2003 vba with WIN7 professional and my old vba code won't work. i create in XP some code lines to read out the user which is log on. now i want to do the same with win7 prof 64bit can someone give me hints ?? thanks in advance
From: joel on 13 Feb 2010 04:40 I haven't usered windows 7 but you need to check the envirnomental variables on you PC to see what they are set to. You are able to do this in XP and Vista by running cmd.exe. Not sure if cmd.exe still exists in windows 7 since microsoft eliminated lots of 16 and 32 bit programs in windows 7. cmd.exe in a classic DOS shell that dates back to the early 1980's. the first DOS PC had command.com which was the window which would open up on these old machines. Then command.com was replaced with cmd.exe. then the DOS shells were replaced with windows 3.0/3.1 (the windows versions less than 3 weren't widely used) and Window 95. IN XP it was simple to run cmd.exe you simply went to the menu Start - run and typed cmd.exe. In vista microsoft made it more difficult and you had to do a search by typing Start - Search and in the search box type cmd.exe. Cmd.exe was really in the windows/system32 folder and could simply go to the folder with a windows explorer and double click on the ICON. If you find cmd.exe then simply type in the DOS window "SET" at the prompt and you will see all the environmental variables. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=179062 [url="http://www.thecodecage.com"]Microsoft Office Help[/url]
From: Per Jessen on 13 Feb 2010 05:12 Hi I am using WIN7 Home Premium 64 bit and XL2007. In the Immediate window I entered the statement: debug.Print environ("Username") and it prompted my username as expected, so I guess you have to look somewhere else to solve the problem. Post your code for further comments, along with an error description and state the line which is highlighted when you click debug. Regards, Per "Jamen Lone" <JamenLone(a)gmx.net> skrev i meddelelsen news:OxVkm0IrKHA.3408(a)TK2MSFTNGP06.phx.gbl... > Hi all, > > I'm using XL2003 vba with WIN7 professional and my old vba code won't > work. > > i create in XP some code lines to read out the user which is log on. > now i want to do the same with win7 prof 64bit > can someone give me hints ?? > > thanks in advance >
From: Gary Keramidas on 13 Feb 2010 10:27 works fine in any combination of the following for me: windows 7 ultimate x64 windows 7 pro x64 excel 2003 excel 2007 excel 2010 -- Gary Keramidas Excel 2003 "Jamen Lone" <JamenLone(a)gmx.net> wrote in message news:OxVkm0IrKHA.3408(a)TK2MSFTNGP06.phx.gbl... > Hi all, > > I'm using XL2003 vba with WIN7 professional and my old vba code won't > work. > > i create in XP some code lines to read out the user which is log on. > now i want to do the same with win7 prof 64bit > can someone give me hints ?? > > thanks in advance >
From: Jamen Lone on 13 Feb 2010 11:42
Thanks .. problem is solved by changing the environmental variables :-) Am 13.02.2010 10:15, schrieb Jamen Lone: > Hi all, > > I'm using XL2003 vba with WIN7 professional and my old vba code won't work. > > i create in XP some code lines to read out the user which is log on. > now i want to do the same with win7 prof 64bit > can someone give me hints ?? > > thanks in advance > |