View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ymeyaw[_8_] ymeyaw[_8_] is offline
external usenet poster
 
Posts: 1
Default 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.


--
ymeyaw
------------------------------------------------------------------------
ymeyaw's Profile: http://www.excelforum.com/member.php...o&userid=34421
View this thread: http://www.excelforum.com/showthread...hreadid=557745