Solved

Display RetVal shell ftp progress/results

Posted on 2002-05-28
7
419 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 143

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
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.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

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

Suggested Solutions

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

820 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