| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i get system id to a excel sheet
i got a workbook. i need the system id to display in a cell on a work sheet.
i am doing vb programing |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i get system id to a excel sheet
Not sure what perameter you are looking for. Below ae some of the system
parameters for Windows XP. Are you looking for the username ? ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents and Settings\Joel\Application Data CLASSPATH=.;C:\Program Files\QuickTime\QTSystem\QTJava.zip CLIENTNAME=Console CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=JOELSCOMPOUTER ComSpec=C:\WINDOWS\system32\cmd.exe FP_NO_HOST_CHECK=NO HOMEDRIVE=C: HOMEPATH=\Documents and Settings\Joel LOGONSERVER=\\JOELSCOMPOUTER NUMBER_OF_PROCESSORS=1 OS=Windows_NT Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\sys tem32\WBEM;C:\Program Files\QuickTime\QTSystem\ PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WS F;.WSH PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 9, GenuineIntel PROCESSOR_LEVEL=15 PROCESSOR_REVISION=0209 ProgramFiles=C:\Program Files PROMPT=$P$G QTJAVA=C:\Program Files\QuickTime\QTSystem\QTJava.zip SESSIONNAME=Console SystemDrive=C: SystemRoot=C:\WINDOWS TEMP=C:\DOCUME~1\Joel\LOCALS~1\Temp TMP=C:\DOCUME~1\Joel\LOCALS~1\Temp USERDOMAIN=JOELSCOMPOUTER USERNAME=Joel USERPROFILE=C:\Documents and Settings\Joel windir=C:\WINDOWS "pswanie" wrote: i got a workbook. i need the system id to display in a cell on a work sheet. i am doing vb programing |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i get system id to a excel sheet
what would the text that i enter in the cell need to look like?
my user account name on the one computer are 'pswanie' and the other computer are 'janphi'. if i open and print the sheet on 'pswanie' i want the cell b2 to say 'pswanie' and if i open and print the sheet (wich is saved on separat on each machin) on 'janphi' i want b2 to say 'janphi' "Joel" wrote: Not sure what perameter you are looking for. Below ae some of the system parameters for Windows XP. Are you looking for the username ? ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents and Settings\Joel\Application Data CLASSPATH=.;C:\Program Files\QuickTime\QTSystem\QTJava.zip CLIENTNAME=Console CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=JOELSCOMPOUTER ComSpec=C:\WINDOWS\system32\cmd.exe FP_NO_HOST_CHECK=NO HOMEDRIVE=C: HOMEPATH=\Documents and Settings\Joel LOGONSERVER=\\JOELSCOMPOUTER NUMBER_OF_PROCESSORS=1 OS=Windows_NT Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\sys tem32\WBEM;C:\Program Files\QuickTime\QTSystem\ PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WS F;.WSH PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 9, GenuineIntel PROCESSOR_LEVEL=15 PROCESSOR_REVISION=0209 ProgramFiles=C:\Program Files PROMPT=$P$G QTJAVA=C:\Program Files\QuickTime\QTSystem\QTJava.zip SESSIONNAME=Console SystemDrive=C: SystemRoot=C:\WINDOWS TEMP=C:\DOCUME~1\Joel\LOCALS~1\Temp TMP=C:\DOCUME~1\Joel\LOCALS~1\Temp USERDOMAIN=JOELSCOMPOUTER USERNAME=Joel USERPROFILE=C:\Documents and Settings\Joel windir=C:\WINDOWS "pswanie" wrote: i got a workbook. i need the system id to display in a cell on a work sheet. i am doing vb programing |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i get system id to a excel sheet
Put the following in a module:
Function UserName() As String UserName = Environ("UserName") End Function then in B2: =UserMame() Mark "pswanie" wrote: what would the text that i enter in the cell need to look like? my user account name on the one computer are 'pswanie' and the other computer are 'janphi'. if i open and print the sheet on 'pswanie' i want the cell b2 to say 'pswanie' and if i open and print the sheet (wich is saved on separat on each machin) on 'janphi' i want b2 to say 'janphi' "Joel" wrote: Not sure what perameter you are looking for. Below ae some of the system parameters for Windows XP. Are you looking for the username ? ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents and Settings\Joel\Application Data CLASSPATH=.;C:\Program Files\QuickTime\QTSystem\QTJava.zip CLIENTNAME=Console CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=JOELSCOMPOUTER ComSpec=C:\WINDOWS\system32\cmd.exe FP_NO_HOST_CHECK=NO HOMEDRIVE=C: HOMEPATH=\Documents and Settings\Joel LOGONSERVER=\\JOELSCOMPOUTER NUMBER_OF_PROCESSORS=1 OS=Windows_NT Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\sys tem32\WBEM;C:\Program Files\QuickTime\QTSystem\ PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WS F;.WSH PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 9, GenuineIntel PROCESSOR_LEVEL=15 PROCESSOR_REVISION=0209 ProgramFiles=C:\Program Files PROMPT=$P$G QTJAVA=C:\Program Files\QuickTime\QTSystem\QTJava.zip SESSIONNAME=Console SystemDrive=C: SystemRoot=C:\WINDOWS TEMP=C:\DOCUME~1\Joel\LOCALS~1\Temp TMP=C:\DOCUME~1\Joel\LOCALS~1\Temp USERDOMAIN=JOELSCOMPOUTER USERNAME=Joel USERPROFILE=C:\Documents and Settings\Joel windir=C:\WINDOWS "pswanie" wrote: i got a workbook. i need the system id to display in a cell on a work sheet. i am doing vb programing |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i get system id to a excel sheet
do appreciate!! that worked...
thanx mark "mark" wrote: Put the following in a module: Function UserName() As String UserName = Environ("UserName") End Function then in B2: =UserMame() Mark "pswanie" wrote: what would the text that i enter in the cell need to look like? my user account name on the one computer are 'pswanie' and the other computer are 'janphi'. if i open and print the sheet on 'pswanie' i want the cell b2 to say 'pswanie' and if i open and print the sheet (wich is saved on separat on each machin) on 'janphi' i want b2 to say 'janphi' "Joel" wrote: Not sure what perameter you are looking for. Below ae some of the system parameters for Windows XP. Are you looking for the username ? ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents and Settings\Joel\Application Data CLASSPATH=.;C:\Program Files\QuickTime\QTSystem\QTJava.zip CLIENTNAME=Console CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=JOELSCOMPOUTER ComSpec=C:\WINDOWS\system32\cmd.exe FP_NO_HOST_CHECK=NO HOMEDRIVE=C: HOMEPATH=\Documents and Settings\Joel LOGONSERVER=\\JOELSCOMPOUTER NUMBER_OF_PROCESSORS=1 OS=Windows_NT Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\sys tem32\WBEM;C:\Program Files\QuickTime\QTSystem\ PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WS F;.WSH PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 9, GenuineIntel PROCESSOR_LEVEL=15 PROCESSOR_REVISION=0209 ProgramFiles=C:\Program Files PROMPT=$P$G QTJAVA=C:\Program Files\QuickTime\QTSystem\QTJava.zip SESSIONNAME=Console SystemDrive=C: SystemRoot=C:\WINDOWS TEMP=C:\DOCUME~1\Joel\LOCALS~1\Temp TMP=C:\DOCUME~1\Joel\LOCALS~1\Temp USERDOMAIN=JOELSCOMPOUTER USERNAME=Joel USERPROFILE=C:\Documents and Settings\Joel windir=C:\WINDOWS "pswanie" wrote: i got a workbook. i need the system id to display in a cell on a work sheet. i am doing vb programing |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i get system id to a excel sheet
Have you tried J-Walk's function for username and comptername ?
If not, here it is: http://j-walk.com/ss/excel/tips/tip94.htm They use API calls. I encorporate them into just about any stand-alone application. "pswanie" schreef in bericht ... do appreciate!! that worked... thanx mark "mark" wrote: Put the following in a module: Function UserName() As String UserName = Environ("UserName") End Function then in B2: =UserMame() Mark "pswanie" wrote: what would the text that i enter in the cell need to look like? my user account name on the one computer are 'pswanie' and the other computer are 'janphi'. if i open and print the sheet on 'pswanie' i want the cell b2 to say 'pswanie' and if i open and print the sheet (wich is saved on separat on each machin) on 'janphi' i want b2 to say 'janphi' "Joel" wrote: Not sure what perameter you are looking for. Below ae some of the system parameters for Windows XP. Are you looking for the username ? ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents and Settings\Joel\Application Data CLASSPATH=.;C:\Program Files\QuickTime\QTSystem\QTJava.zip CLIENTNAME=Console CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=JOELSCOMPOUTER ComSpec=C:\WINDOWS\system32\cmd.exe FP_NO_HOST_CHECK=NO HOMEDRIVE=C: HOMEPATH=\Documents and Settings\Joel LOGONSERVER=\\JOELSCOMPOUTER NUMBER_OF_PROCESSORS=1 OS=Windows_NT Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\sys tem32\WBEM;C:\Program Files\QuickTime\QTSystem\ PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WS F;.WSH PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 9, GenuineIntel PROCESSOR_LEVEL=15 PROCESSOR_REVISION=0209 ProgramFiles=C:\Program Files PROMPT=$P$G QTJAVA=C:\Program Files\QuickTime\QTSystem\QTJava.zip SESSIONNAME=Console SystemDrive=C: SystemRoot=C:\WINDOWS TEMP=C:\DOCUME~1\Joel\LOCALS~1\Temp TMP=C:\DOCUME~1\Joel\LOCALS~1\Temp USERDOMAIN=JOELSCOMPOUTER USERNAME=Joel USERPROFILE=C:\Documents and Settings\Joel windir=C:\WINDOWS "pswanie" wrote: i got a workbook. i need the system id to display in a cell on a work sheet. i am doing vb programing |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
| i need a stock control system sheet | Excel Discussion (Misc queries) | |||
| need mail merge system for excel spread sheet | Excel Worksheet Functions | |||
| How can I disable system alerts (deleting a sheet for example)? | Excel Discussion (Misc queries) | |||
| excel causing system to be in low system resource | Excel Discussion (Misc queries) | |||
Linear Mode
