ThaNguyen
07-11-2008, 10:39 AM
I have an ftp folder ftp://192.168.20.1/HOLDDATA/ that has many files generated daily here.
I can use excel to open these text file by using open file, it will prompt with a name and password.
How do I put it in vba code with name and password and open a text file?
I used record macros it will work only if I already logged in this folder once with name and password
this is part of the recorded code
Workbooks.OpenText Filename:="ftp://192.168.20.1/HOLDDATA/AR"
Any help would be greatly appreciated
I can use excel to open these text file by using open file, it will prompt with a name and password.
How do I put it in vba code with name and password and open a text file?
I used record macros it will work only if I already logged in this folder once with name and password
this is part of the recorded code
Workbooks.OpenText Filename:="ftp://192.168.20.1/HOLDDATA/AR"
Any help would be greatly appreciated