Operating a dos like window(screen) with the help of excel
Is this possible , to operate a dos like window(screen like dos) already opened at the desktop with the help of Excel.
The task is to write a predefined command on this window(screen) and then press enter automatically by excel.
Can we make an excel macro button which will automatically switch over to that dos like window and will automatically write predefined command on that screen and will press button enter.
Someone told me we can use SENDKEYS???dunno wats that.Wats is the code for excel-VB by which i can switch over to that already opened window(screen like DOS)
Can anyone guide, plz.
operating cmd.exe
Thank you very much-ur code very effective,,some concern.plz see
Hi sir, how are u..
Thank u very much for the code you provided.
Its working well.
I have some more questions to ask u .Now the code u gave it possible to switch over to that DOS like screen by running excel macro..
My next task is to retrieve some text from that screen.Like at some specific cursor position in that DOS like screen i wana check what is written.Like check at (2,3) cursor if written =1.
Can u plz suggest some code ...
Thank you.
You could try to redirect the
You could try to redirect the output of your App (dos?) to a txt file and manipulate that.
If it is dos you're using:
The DOS command to redirect output is >. Use it like this:
Dir *.xls > c:\myfile\excel\MyXLSFiles.txt
Don't forget to build in a delay function because it takes time to create the file.
thank u very much JPH,but
thank u JPH,,,but i wana write a command in excel that automatically copy some text from that DOS like screen,,Its not actually dos.Its not an exe.
Ok, first step is taken. You
Ok, first step is taken. You activate the screen.
Because I don't know which program you use it is hard to give an answer as to how you can "manipulate" content.
Did you try Google to find out what you can do to "manipulate" content via VBa?
Grtnx,
JPH
not logged in
sry i was not logged in while placing the comment above.
Why doesn't my computer remember this.