Hi,
I have the file(F1.XL) in Unix Box. it's updating every 1hr.
I would like to import f1.xl to Windows excel sheet, when i need see the reports.

can any one clarify, is there any VB script for importing data from UNIX, like sql connection....
thanks

If you have ftp enabled, then try the below in VB or VBA


Sub ftp(source_path As String, source_file As String, ip As String)
Open "c:\ftp_input.txt" For Output As #1
Print #1, "open " & ip
Print #1, "Enter ftp userid here"
Print #1, "Enter ftp password here"
Print #1, "lcd " & "c:\paf_local"
Print #1, "prompt"
Print #1, "cd " & source_path
Print #1, "get " & source_file
Print #1, "bye"
Close #1
End Sub


Sub Button1_Click()
Call ftp(filepath,filename,server-ip)
pid=shell("ftp -is:c:ftp_input.txt")
End Sub