how to use FTP in VBA

dear all experts,

I need your help on using FTP in VBA.I had a file in unix which stored at
/home/daniel/dailyreport.txt. I wish to use VBA code to import this txt file and put into excel worksheet.

The daily report.txt is somthing like this:
name ip
david 100.24.56.78
richard 100.33.44.56


How can this be done? Currently i had to use another ftp software just to do that.

Hello Ymeyaw,

Here is some code that should help...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

hi Leith Ross,

Thanks for ur greatest help.This is really helpful. I did studied the code below, there is one line which i dont really know why the owner what to do this way?

Print #lInt_FreeFile02, "Echo ""Complete"" > " & strDirectoryList & ".out"