This post is a mixture or this one from Excely and this other one from MyEngineeringWorld, and has been completed with IP detectors, and download links for referred software.
SSH client and secure file transferOn a day-to-day basis, it becomes necessary to upload/download files from/to the remote server. First of all, access to the server is need. It can be set up through FTP and SSH protocols by using such programs as PuTTY (is an opensource SSH and telnet client) or WinSCP (is an SFTP client and FTP client for Microsoft Windows). They will allow you to remotely connect a server to a PC and transfer files within the established network. Let’s have a look at the example of using simple SSH client for uploading and downloading files based on Excel. It is possible to modify it to ease the automation of tasks on the remote server. To access the server, we need to know the following:
- IP address
- SSH port (22 by default)
As it can be seen from above, there are three main functions used in the program: connection to the server, uploading and downloading files to/from the server
How to connect to SFTPSFTP (Secure File Transfer Protocol) is similar to SSH protocol. However, it enables secure connection for transferring files not only remotely but locally as well. As the SSH protocol, SFTP has the same method of authentication. You will need to know:
- Host name of the server;
- Protocol of the server (SFTP, FTP, etc.);
How to upload files through SFTPBefore you start uploading files, make sure that your user account is connected to the SFTP server. To upload/download files, you might do the following: drag and drop icons (files) from one PC file system to another one; use copy/paste or choose an option “Send to” in a context menu. Any changes relating SFTP settings can be made in the SFTP commander interface.
Calling PuTTY from Excel VBAPuTTY which is a file transfer application can be opened manually or automatically depending on settings. To start PuTTY session from VBA, you will need a VBA command line. To open current VBA session in PuTTY, it is needed to enter following details in the login window:
- Host name you are connecting to;
- And press “Start PuTTY”.