![]() ( I have not seen it either in Any Office 2007, but I have only a few Office 2007s, so that may not be too conclusive). I Have never experienced it in Office 2003. I have seen this strange effect several times on all my Win7 computers and at least once in all Office 2010. I tried on a several Windows 7 machines, all have Office 2003 most also have Office 2010, and a couple Office 2007Ĭode line 1 gives me in test1.txt what I get if I do it manuallyĬode line 2 gives me in test2.txt what I get if I do it manuallyĬode line 3 and code lines 4 give mixed up results. ( In some casers I used a path to my desktop instead… which revealed a simple problem which had me frustrated all day.**** P.S: here an attempt to summarise pictoriareally wot I am doing manually and what I want to try to automate, preferably with VBAĪction Sumary.JPG: " onclick="window.open(this.href) return false Ĭode: Select all Sub ShellBlackCommandPromptWindowAutomatingCopyingWindowContent()ġ Shell "cmd.exe /c ""ipconfig /all > """ & ThisWorkbook.Path & "\test1B.txt"""""Ģ Shell "cmd.exe /c ""route print > """ & ThisWorkbook.Path & "\test2B.txt"""""ģ Shell "cmd.exe /c ""ipconfig /release > """ & ThisWorkbook.Path & "\test3B.txt"""""Ĥ Shell "cmd.exe /c ""ipconfig /renew > """ & ThisWorkbook.Path & "\test4B.txt""""" This is the same as Action 1, except that the two commands to be used areĬan 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 ![]() ( Paste Contents from cmd window into text file.JPG : " 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). I right click with the mouse at the top of the window again, and this time, select Edit - Copy ( Edit - Copy cmd window.jpg : " onclick="window.open(this.href) return false, " onclick="window.open(this.href) return false ) I right click with the mouse at the top of the window, and select Edit - Select All ( Edit - Select All cmd window.jpg : " onclick="window.open(this.href) return false, " onclick="window.open(this.href) return false ) I now have the black command window console thing full with text that I want to copy. Route print ( route print.jpg : " onclick="window.open(this.href) return false ) ![]() Then I type in after the > another command: Ipconfig /all ( ipconfig all.jpg : " onclick="window.open(this.href) return false ) In the black command window console thing which comes up, I type in after the > a command: ( Microsoft Symbol+r cmd OK.jpg : " onclick="window.open(this.href) return false ) I bring up the black command window console thing, for example using _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.īroadly I can summarise what I am currently doing into two main actions: I was wondering if anyone knows of ways to automate all or some of this. Mostly I am initially needing to do this in XP operating system. ( Black cmd window thing.JPG : " onclick="window.open(this.href) return false, " onclick="window.open(this.href) return false, " onclick="window.open(this.href) return false, " onclick="window.open(this.href) return false, ) 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. I think this is a Windows General question, with a possible leaning towards VBA … Hi, festive greetings to everyone, hope you are all well. Operating System Command Prompt Shell Black Window thing: Automating: getting it up Commands copying contents to a text file…
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |