Launching cmd.exe from VBA

[ken2834]

I have a VBA module that launches a DOS command console (cmd.exe) in order to login to a Unix session and then run some FTP commands to pull down a file from the Unix server. However, I would like to be able to parse the output in the console to determine if the login occurred successfully. Is this possible? I don't see a way to do this.

 

[CautionMP]

ken2834,
From the command prompt you can ouput the screen to a file using [tt]> filename[/tt], for example you can create a file with directory listing using the following:

C:\>[b]dir > c:\testfile.txt[/b]

I get the following output:

[tt]
Volume in drive C is Preload
Volume Serial Number is F8B1-679E

Directory of C:

02/26/2007 10:08 PM <DIR> .
02/26/2007 10:08 PM <DIR> ..
02/20/2007 10:02 PM 392 iexplore.exe_Trace.txt
1 File(s) 392 bytes
2 Dir(s) 41,524,248,576 bytes free[/tt]

It should work with anything you do from the command prompt that returns 'stuff'. Once file is created it's pretty easy to open/read/process in VBA.

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[ken2834]

Yes, thanks.