How to execute a carriage return (Enter) in VBA

[vamoose]

Code goes like this:

Shell ("FTP 172.16.7.10")
Now I need a carriage return, (Enter) command
Shell ("Put c:\temp\ML7807103.txt")
Now I need a carriage return, (Enter) command
Quit
Now I need a carriage return, (Enter) command

Does anyone know the correct syntax for this command ?
Thank you for any assistance.

 

[SkipVought]

Hi,

vbCR is a VB constant for carriage return.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[PHV]

Why not using the -s:CommandFile command line option of the ftp.exe command ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vamoose]

Please explain the -s:CommandFile command line option of the ftp.exe command ? Not familiar with this, Thanks

 

[VicRauch]

A google search is a wonderful thing:
I entered "-s:CommandFile command line option of the ftp.exe" and got the following link as the TOP one of google's 153,000 possible sites to view:
[URL unfurl="true"]http://www.tinyapps.org/ftp.html[/url]

Looks to me like this should explain it quite well.

 

[PHV]

In a console windows (cmd.exe) type the following:
ftp -?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vamoose]

Alright, that worked great but now another problem.
My ftp -s:CommandFile contains 1 put variable which is constantly changing. Is there a way to pass a variable into the .txt file before the put command is executed ? Thanks

 

[VicRauch]

This site will explain it!

http://www.tinyapps.org/ftp.html

Good luck,
Vic