PDA

View Full Version : Ftp Folder



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