Remember Me?
Menu
Home
Search
Today's Posts
Home
Search
Today's Posts
ExcelBanter
»
Excel Newsgroups
»
Excel Programming
>
FTP using CMD via VBA
LinkBack
Thread Tools
Search this Thread
Display Modes
Prev
Next
#
10
Posted to microsoft.public.excel.programming
sachin ahuja
external usenet poster
Posts: 12
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 With Quote
Thread Tools
Search this Thread
Show Printable Version
Search this Thread
:
Advanced Search
Display Modes
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
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
06:56 AM
.
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
Contact Us
ExcelBanter forum home
Privacy Statement
LinkBack
LinkBack URL
About LinkBacks