Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you open a new spreadsheet in a new program window? | Excel Discussion (Misc queries) | |||
can't open new worksheets in a separate window | Excel Discussion (Misc queries) | |||
open file in different window | Excel Discussion (Misc queries) | |||
open new window | Excel Discussion (Misc queries) | |||
How do open each excel file in its own window | Excel Discussion (Misc queries) |