Re: Getting an AS/400 Printout into Excel...

[Vernon Hamberg <hambergv@xxxxxxxxxxxxxx>]

Chuck

At 02:46 PM 6/30/1998 -0400, you wrote:
>Rob !
>
>Thanks, that was it ! MAN is that slick (and BOY does THAT open up a
hole... <BG>...
>I've learned a BUNCH in a little information and I SURE appreciate your
help !

You have no idea the hole you opened up! If you are in your FTP session on
your PC and type

        quote rcmd any_CL_command_string

it'll run on the 400!

Howdya like them apples?

Now try to sleep at night!  <bg>

BTW, you can put the various ftp subcommands into a text file on your PC
and run them through ftp without having to type them in. Then you can do
your transfers from a .bat file or VB or whatever. Syntax is

        ftp xxx.xxx.xxx.xxx -sftp_script_file_name

Script can look like

        user user_name
        pass password
        cd some_directory_or_library
        get some_file
        quit

Have fun. Look in the FTP chapter in the 400 TCP/IP Config & Ref for some
ideas, look under FTP in Batch or something like that.

Cheers

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---