Please help with Shell command statement & arguments 1

[vamoose]

I am trying to combine the following Shell command and arguments into a one line VB statement. Can anyone provide any suggestions. I have tried the FTP -s:CommandFile command and that works fine but I am trying to pass different text files at different times contained in the c:\temp directory. Thank you.

Shell ("FTP -v -n 172.16.7.10")
put c:\temp\ML78071.txt
quit

 

[PHV]

I have tried the FTP -s:CommandFile command and that works fine
So, where is the problem ?
How did you that ?
I am trying to pass different text files at different times
So, write on the fly a command file at each time.

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

 

[vamoose]

This would be great, do you possibly have an example I can work from. I am not familiar on how to create, write and save a text file using VBA. Any help would be greatly appreciated. Thank you.

 

[PHV]

In the VBA help have a look at the Open, Print # and Close instructions.
An alternate way:

http://msdn.microsoft.com/library/en-us/script56/html/af4423b2-4ee8-41d6-a704-49926cd4d2e8.asp

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

 

[vamoose]

I have this working now but I have a few comments/questions:
1. When I open the file as input I cannot use the Print or Write commands. I must open as append to use Print or Write commands. This places the new text on the bottom of the existing text.
2. I cannot get the file to close without saving the changes
3. I need a blank document to be opened, written to, used, then discard the changes returning to a blank document. Am I on the right track ? Thanks.

 

[PHV]

Open the file as Output.

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