Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() You can get the PC Name by usding the environmental variable COMPUTERNAME computerName = environ("COMPUTERNAME") You can get the IP address from the computername by doing a ipconfig command to the host name. From a sheel prompt 1) Start - run - c:\windos\system32\cmd.exe 2) ipconfig You can run these commands from a sheel command like this ComputerName = Environ("ComputerName") Shell "cmd /c C:\windows\system32\ipconfig c:\temp\ipconfig.txt", 0 You can then open the text file to get the results. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194661 http://www.thecodecage.com/forumz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hostname from IP address | Excel Worksheet Functions | |||
How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
Converting list of IP Addresses to list of Hostname | Excel Worksheet Functions | |||
Get IP address for a remote computer based on its hostname | Excel Programming | |||
LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info | Excel Programming |