Operating System Command Prompt Shell Black Window thing: Automating: getting it up; Commands; copying contents to a text file…
Hi, festive greetings to everyone, hope you are all well. I think this is a Windows General question, with a possible leaning towards VBA …
One of my Winter computer projects this year involves a lot of tedious similar measurements associated with internal settings, and fiddling with internet stuff… some of which I am currently getting mostly manually via the black cmd window thingy. ( Black cmd window thing.JPG : https://imgur.com/okgmnt4" onclick="window.open(this.href);return false; , https://imgur.com/V7KpWld" onclick="window.open(this.href);return false; , https://imgur.com/KguV4xr" onclick="window.open(this.href);return false; , https://imgur.com/JVrPIUD" onclick="window.open(this.href);return false; , )
Mostly I am initially needing to do this in XP operating system.
I was wondering if anyone knows of ways to automate all or some of this.
Automation will both:
_a) Save me time
_b) help me get more consistent results: Some things which I am looking at react differently if a command is given at a specific time after another: It is difficult to accurately do a command at a specific time when doing them manually.
Broadly I can summarise what I am currently doing into two main actions:
Action 1
I bring up the black command window console thing, for example using
Microsoft Symbol+r
cmd
OK
(Microsoft Symbol+r cmd OK.jpg : https://imgur.com/TUvExlW" onclick="window.open(this.href);return false; )
In the black command window console thing which comes up, I type in after the > a command:
Ipconfig /all ( ipconfig all.jpg : https://imgur.com/BYyTzcc" onclick="window.open(this.href);return false; )
Then I type in after the > another command:
route print ( route print.jpg : https://imgur.com/IZLAD3r" onclick="window.open(this.href);return false; )
I now have the black command window console thing full with text that I want to copy. I do this currently like this:
I right click with the mouse at the top of the window, and select Edit --- Select All (Edit --- Select All cmd window.jpg : https://imgur.com/tJtkP08" onclick="window.open(this.href);return false; , https://imgur.com/S3wQPXj" onclick="window.open(this.href);return false; )
I right click with the mouse at the top of the window again , and this time, select Edit --- Copy (Edit --- Copy cmd window.jpg : https://imgur.com/s9iGu0m" onclick="window.open(this.href);return false; , https://imgur.com/MV49iDT" onclick="window.open(this.href);return false; )
I open a text file, and paste the contents from the clipboard into it, ( for example via Key combination Ctrl+v or by selecting the insert option after right mouse clicking when in the text file).
(Paste Contents from cmd window into text file.JPG : https://imgur.com/maOfUEe" onclick="window.open(this.href);return false; )
Action 2
This is the same as Action 1, except that the two commands to be used are
Ipconfig /release
Ipconfig /renew
Can anyone tell me how to automate all or some of this? It would be particularly useful if I can automate using VBA, since I know how to then further manipulate the text files using VBA
Thanks
Alan
P.S: here an attempt to summarise pictoriareally wot I am doing manually and what I want to try to automate, preferably with VBA
Action Sumary.JPG: https://imgur.com/dHgTOZC" onclick="window.open(this.href);return false;