Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default FTP using CMD via VBA

I am using below functionality and wanna read content after Pressing Enter on 7 line.
i.e. I need "BAS7544.P.EFT.METLIFE.EOI.G0596V00" to be copied in a cell in the excel.


1. C:\ftp
2. ftp open mvsftp
Connected to l4dupfw113.Server.com.
220- --- NOTICE! ---
220-This is a private computer facility protected by a security system.
Access
220-to and use of this facility requires explicit written, current authorization
220-and is strictly limited to the purposes of this organization's business.
220-Unauthorized or any attempt at unauthorized access, use, copying,
220-alteration, destruction or damage to its data, programs, or equipment may
220-violate the Federal Computer Fraud and Abuse Act of 1986 as well as applicable
220-state law and may result in criminal or civil liability, or both.
220-
220-Associates File Transfer Protocol Proxy
220-Please enter the userid and the remote host you wish to connect to
220-(e.g. )
220-at the user prompt and enter your password at the password
220 prompt. Please contact the Support Center if you encounter difficulties.
3. User (l4dupfw113.server.com:(none)):
331-(----GATEWAY CONNECTED TO 10.100.20.23----)
331-(220-TCPFTP1 IBM FTP CS V2R1 at L4DMPSYSC, 02:28:15 on 2014-08-05.)
331-(220 Connection will close if idle for more than 15 minutes.)
331 Send password please.
4. Password:
230 @F5658 is logged on. Working directory is "@F5658.".
5. ftp get
6. Remote file 'BAS7544.P.EFT.METLIFE.EOI(0)'
7. Local file c:\pat\abc.txt
200 Port request OK.
125 Sending data set BAS7544.P.EFT.METLIFE.EOI.G0596V00 FIXrecfm 80
250 Transfer completed successfully.
ftp: 92 bytes received in 0.00Seconds 92.00Kbytes/sec.
ftp


Please help me.

Thanks,

On Tuesday, August 5, 2014 10:32:40 AM UTC+5:30, Auric__ wrote:
sachin ahuja wrote:



Need your help again.


I wanna copy text from FTP window before typing "bye" on "cmd" in above


code snippet.




Why? What are you trying to accomplish?



The only way I know of involves using the Windows API... but it's been so

long since I needed to do so that I don't remember how any more.



--

The burning smell kept reminding me, I shouldn't'a gotten involved.




On Tuesday, August 5, 2014 10:32:40 AM UTC+5:30, Auric__ wrote:
sachin ahuja wrote:



Need your help again.


I wanna copy text from FTP window before typing "bye" on "cmd" in above


code snippet.




Why? What are you trying to accomplish?



The only way I know of involves using the Windows API... but it's been so

long since I needed to do so that I don't remember how any more.



--

The burning smell kept reminding me, I shouldn't'a gotten involved.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"