Display RetVal shell ftp progress/results

I execute a command:

RetVal=Shell("ftp -i -n -s:c:\myexe\ftp_process", 1)

The ftp_process file contains my login and send file commands.

The MSDOS window pops up with the ftp results and goes away, but I would like to see these in a window that I can "OK" or something before it goes away.  Is there anyway to do this?  I'm using a VB macro in an Excel 97 ap.
robjayAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
If you call a .bat file that contains your ftp commands, you can of course add any other commands you want or need, like "pause"...
CHeers
0
 
zhangjingCommented:
The shell command calls a file called "conagent.exe" under windows\system folder, if you double click it, it will flash then disappear, there is no way to make it stay there.
0
 
zhangjingCommented:
angellll's answer is a really cool one!
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
bruintjeCommented:
Hi robjay, any update on this one? :O)Bruintje
0
 
bruintjeCommented:
last try next round i'll put this in the automatic cleanup

Hi Robjay, if you could provide some fedback we can learn if this problem was solved or that you need some more help

Thanks
0
 
bruintjeCommented:
PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

time to clean up

-if not stated otherwise

my recom will be
-PAQ
-points to angelIII
-this will be finalized with no further update (04.08.2002)

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
0
 
NetminderCommented:
Per recommendation, force-accepted.

Netminder
CS Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.