Connect unix server through VBA

[Jayaseelan]

Hi,

Would anyone please help me by telling me how I can connect to a unix server through VBA?

Example:

Unix server:
IP: 10.10.10.09
PORT: 12345

credentials:
username: user
Password: pwd

how i can connect to the above mentioned server with the credentials and then execute some commands?

Any help?

 

[John_w]

Create C:\FTP_commands.txt containing:

open 10.10.10.09 12345
user yourUsername pwd
cd your/unix/directory
!REM more commands here
bye

Then run it with:

Public Sub Ftp_Test()

    Dim FTPcommand As String
    Dim wsh As Object
    
    FTPcommand = "ftp -n -s:" & Chr(34) & "C:\FTP_commands.txt" & Chr(34)
    Set wsh = CreateObject("WScript.Shell")
    wsh.Run FTPcommand, 5, True
    
End Sub