Text File to Fixed IP Address

**4sharkfins** · 08-28-2009, 11:35 PM

Hello

I am not sure this has been asked in the forum before. I have searched the threads but could not find the solution to my query which is to create a text file from an xls sheet and saved in a given IP address. I know how to create a text file in a local directory using the following procedure

Open "D:\Mydiectory\Upoad\Textfilename.txt" For Output As #1
…….

Print #1
…….

Close #1

But when I changed the directory name to the IP address, I got a bad filename error. I suspected that the slash in IP is facing the wrong direction. The IP is in the format – “ftp://10.12.34.567/ABCD/EF/” Any suggestion will be much appreciated.

**Richard Schollar** · 08-29-2009, 03:28 AM

Hi

I may be wrong but I think you will need to create the text file locally and then use an FTP client to upload the file to the destination. You could use the command-line Windows ftp client for this (should be available if you have at least Windows XP). Go Start>Run and type ftp into the command dialog. If a command line opens up that looks like

ftp >

then you have the ftp command line tool available.

If you can do this, write back and I'll try and help you with the ftp commands required on the command line (don't have much experience with this though). You should be able to execute them via the Shell VBA function, or should be able to create a batch script which you can execute via VBA to do it.

Richard