Solved

Display RetVal shell ftp progress/results

Posted on 2002-05-28
7
413 Views
Last Modified: 2008-03-06
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.
0
Comment
Question by:robjay
7 Comments
 
LVL 2

Expert Comment

by:zhangjing
ID: 7040883
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
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 75 total points
ID: 7041106
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
 
LVL 2

Expert Comment

by:zhangjing
ID: 7041258
angellll's answer is a really cool one!
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 44

Expert Comment

by:bruintje
ID: 7064234
Hi robjay, any update on this one? :O)Bruintje
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7118611
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
 
LVL 44

Expert Comment

by:bruintje
ID: 7183246
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
 
LVL 5

Expert Comment

by:Netminder
ID: 7199492
Per recommendation, force-accepted.

Netminder
CS Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now