Can you FTP a file/data directly into Excel
 

Has anyone ever FTP a file/data directly into an Excel worksheet from a FTP sever?

At present I manually FTP these files when they are created and drop them onto my hard drive then i export it into Excel for processing. This is becoming very time consuming as the number of files are growing in number.

Regards,
TDR

did you try data(menu bar)-get external data-new webquery


--
remove $$$ from email addresss to send email


TDR wrote in message
...

Has anyone ever FTP a file/data directly into an Excel worksheet from a
FTP sever?

At present I manually FTP these files when they are created and drop
them onto my hard drive then i export it into Excel for processing.
This is becoming very time consuming as the number of files are growing
in number.

Regards,
TDR


--
TDR