View Full Version : Ftp Folder

07-11-2008, 10:39 AM
I have an ftp folder 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:=""

Any help would be greatly appreciated