Hi,
Thanks. I have tried this method before, but using this does not allow me to define the width of each of the columns of the text file that I am importing. Using a text import allows me to define the width but does not allow me to specify the userid and password into the server. Is there any way I can do both?
"keepITcool" wrote:
According to the specification of URL formats, RFC 1738, an FTP URL is of
the form ftp://user:password@host:port/path
So.. you can just create a webquery with a proper ftp url..
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool
"?B?Qmx1ZXk=?=" wrote:
Hi,
I need to import a text file from a server via ftp into excel using
macro. How can I do this without having to manually key in the user id
and password but have it done inside the macro? I would greatly
appreciate it if anyone can provide any form of information. Thanks.