Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to execute a program and return it's output to me in VBA.
I need to execute an FTP program and return directory information from the
ftp'd computer so I can manipulate it in VBA. I know how to write a batch file to start the program and the file the batch file starts. What I don't know is how to start the process in VB so I get the output of running the program back to my VBA program. Thanks, Mac in Berkeley |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to execute a program and return it's output to me in VBA.
Hello Mac
See help on Shell in VBA help. HTH Cordially Pascal "Mac Lingo" a écrit dans le message de news: ... I need to execute an FTP program and return directory information from the ftp'd computer so I can manipulate it in VBA. I know how to write a batch file to start the program and the file the batch file starts. What I don't know is how to start the process in VB so I get the output of running the program back to my VBA program. Thanks, Mac in Berkeley |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to execute a program and return it's output to me in VBA.
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 -- Regards, Tom Ogilvy "Mac Lingo" wrote: I need to execute an FTP program and return directory information from the ftp'd computer so I can manipulate it in VBA. I know how to write a batch file to start the program and the file the batch file starts. What I don't know is how to start the process in VB so I get the output of running the program back to my VBA program. Thanks, Mac in Berkeley |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to execute a program and return it's output to me in VBA.
Ha ha.
There is a way to capture the output. But because you didn't try the ftp script solution I posted for your same question yesterday, I'm not going to give it to you. All right. I'll give you a tip ... ftp -s example.scr ftp_output.txt |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
I didn't get it before.
Piping is such a simple answer. And thank you very much.
Tho I don't get the reason for the "scr" type. I've figured out how to do it with an ordinary batch file, but I couldn't even figure out what the "scr" type was for. I guess scripting, but I don't know anything about programming in that enviornment. Mac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use Excel VBA program to execute SQL SERVER stored procedur | Excel Programming | |||
getting vba shell command to execute batch and save output to a file | Excel Programming | |||
execute external program when cell reaches certain value | Excel Worksheet Functions | |||
Execute a program from within VBA | Excel Programming | |||
Execute program (macro?) upon opening a workbook | Excel Programming |