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.
Bookmarks