OPen an DOS WIndow
 

I would like to create a button in a form in a spreadsheet then use some
vba code that will open a the command prompt window then automatically
enter "ipconfig" in the command prompt window to display my IP
address.

Many thanks


--
nathandaviesuk
------------------------------------------------------------------------
nathandaviesuk's Profile: http://www.excelforum.com/member.php...o&userid=10790
View this thread: http://www.excelforum.com/showthread...hreadid=495155

OPen an DOS WIndow
 

Three steps:

1. Create a .bat file with
ipconfig /all
pause

2. Create a macro:
Sub Macro1()
x = Shell("cmd.exe /c C:\ip.bat", 1)
End Sub

3. Make a button and associate the macro with it.



--
Gary's Student


"nathandaviesuk" wrote:


I would like to create a button in a form in a spreadsheet then use some
vba code that will open a the command prompt window then automatically
enter "ipconfig" in the command prompt window to display my IP
address.

Many thanks


--
nathandaviesuk
------------------------------------------------------------------------
nathandaviesuk's Profile: http://www.excelforum.com/member.php...o&userid=10790
View this thread: http://www.excelforum.com/showthread...hreadid=495155