Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing a text file using ftp
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing CSV file (saved as Text) into XL as Text -- over 60 colu | Excel Discussion (Misc queries) | |||
Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
Importing text file | Excel Discussion (Misc queries) | |||
importing text file, removing data and outputting new text file | Excel Programming | |||
Need Help in importing text file | Excel Programming |