Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run an External .exe
Is it possible from Excel (using the buttons) to:
1) run an external .exe 2) When the .exe finishes pick up the outputs of the .exe in excel Thanks again, Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run an External .exe
You can run external programs using the shell command, but as for picking up
the outputs, are they being stored somewhere or just how do you propose getting them. -- HTH... Jim Thomlinson "Dan" wrote: Is it possible from Excel (using the buttons) to: 1) run an external .exe 2) When the .exe finishes pick up the outputs of the .exe in excel Thanks again, Dan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run an External .exe
Jim,
Thanks, Could you please provide an example of this "shell" command. Wrt picking up, the .exe ouputs a text file. Do I have a way to know when the .exe finished, ie: when this text file is ready for pick up? I would like to do all this automatically from Excel, in this way, I could run pre existing .exe routines, which are transparent to me in excel and then pick up results and post process in excel. Thx again Dan "Jim Thomlinson" wrote: You can run external programs using the shell command, but as for picking up the outputs, are they being stored somewhere or just how do you propose getting them. -- HTH... Jim Thomlinson "Dan" wrote: Is it possible from Excel (using the buttons) to: 1) run an external .exe 2) When the .exe finishes pick up the outputs of the .exe in excel Thanks again, Dan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run an External .exe
http://support.microsoft.com/?id=214248
XL2000: How to Force Macro Code to Wait for Outside Procedure http://support.microsoft.com/?id=129796 HOWTO: 32-Bit App Can Determine When a Shelled Process Ends http://support.microsoft.com/?id=147392 XL: How to Force Macro Code to Wait for Outside Procedure -- Regards, Tom Ogilvy "Dan" wrote in message ... Jim, Thanks, Could you please provide an example of this "shell" command. Wrt picking up, the .exe ouputs a text file. Do I have a way to know when the .exe finished, ie: when this text file is ready for pick up? I would like to do all this automatically from Excel, in this way, I could run pre existing .exe routines, which are transparent to me in excel and then pick up results and post process in excel. Thx again Dan "Jim Thomlinson" wrote: You can run external programs using the shell command, but as for picking up the outputs, are they being stored somewhere or just how do you propose getting them. -- HTH... Jim Thomlinson "Dan" wrote: Is it possible from Excel (using the buttons) to: 1) run an external .exe 2) When the .exe finishes pick up the outputs of the .exe in excel Thanks again, Dan |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run an External .exe
Here is how you use the shell command...
Sub RunProgram() Shell ("C:\Windows\Notepad.exe") End Sub You can use a file system object to read the text file and depending you can try using DoEvents 'to make sure the process has completed or Use OnTime to specify a wait time -- HTH... Jim Thomlinson "Dan" wrote: Jim, Thanks, Could you please provide an example of this "shell" command. Wrt picking up, the .exe ouputs a text file. Do I have a way to know when the .exe finished, ie: when this text file is ready for pick up? I would like to do all this automatically from Excel, in this way, I could run pre existing .exe routines, which are transparent to me in excel and then pick up results and post process in excel. Thx again Dan "Jim Thomlinson" wrote: You can run external programs using the shell command, but as for picking up the outputs, are they being stored somewhere or just how do you propose getting them. -- HTH... Jim Thomlinson "Dan" wrote: Is it possible from Excel (using the buttons) to: 1) run an external .exe 2) When the .exe finishes pick up the outputs of the .exe in excel Thanks again, Dan |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run an External .exe
Very Nice... I never have to wait for outside apps but if I ever do this will
be handy. Thanks Tom... I was very suspicious of whether DoEvents would work. I had my doubts... -- HTH... Jim Thomlinson "Tom Ogilvy" wrote: http://support.microsoft.com/?id=214248 XL2000: How to Force Macro Code to Wait for Outside Procedure http://support.microsoft.com/?id=129796 HOWTO: 32-Bit App Can Determine When a Shelled Process Ends http://support.microsoft.com/?id=147392 XL: How to Force Macro Code to Wait for Outside Procedure -- Regards, Tom Ogilvy "Dan" wrote in message ... Jim, Thanks, Could you please provide an example of this "shell" command. Wrt picking up, the .exe ouputs a text file. Do I have a way to know when the .exe finished, ie: when this text file is ready for pick up? I would like to do all this automatically from Excel, in this way, I could run pre existing .exe routines, which are transparent to me in excel and then pick up results and post process in excel. Thx again Dan "Jim Thomlinson" wrote: You can run external programs using the shell command, but as for picking up the outputs, are they being stored somewhere or just how do you propose getting them. -- HTH... Jim Thomlinson "Dan" wrote: Is it possible from Excel (using the buttons) to: 1) run an external .exe 2) When the .exe finishes pick up the outputs of the .exe in excel Thanks again, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
How do I fix problems with the external USB 10-key pad? | Setting up and Configuration of Excel | |||
external data | Excel Discussion (Misc queries) | |||
External dll | Excel Programming |