Solved

Display RetVal shell ftp progress/results

Posted on 2002-05-28
7
410 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
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…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

760 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

20 Experts available now in Live!

Get 1:1 Help Now