Develop VBA tool to send file via SFTP

Dieses Projekt wurde jperusan für £12 GBP / Stunde vergeben.

Erhalten Sie kostenlose Angebote für ein Projekt wie dieses
Arbeitgeber arbeiten
Vergeben an:
Erforderliche Fähigkeiten
£10 - £15 GBP / hour

I require a tool to be developed in VBA, for use in Microsoft Excel, which will allow a ‘one-button press’ to generate a file in PHP and send this file to a server via SFTP.

The first part of the tool, generating the PHP file, has been developed. The second part, sending the file to the server via SFTP, has not.

I have found code on StackOverflow which may provide an ideal foundation. However, my knowledge of VBA and SFTP is not good enough to be able to implement something such as this.

[url removed, login to view]

It should be noted that I tried to apply the answer suggested by Nick Peranzi in the above SO, but received an error on the 9th line of the CheckOutput function which I wasn't able to solve myself.

The ideal solution would be to use as little from third party applications as possible. However, as I understand that Windows does not natively support SFTP, an interface with a program such as WinSCP may be inevitable.

Either way, as this tool will be distributed to various other team members, the fewer steps required with installation of additional software, the better.

The tool needs to work in version of Excel from 2010 up to 2016. I will provide the SFTP details for a test folder.

One final note is that the website to which the file needs to be sent is hosted with 1and1.

Möchten Sie Geld verdienen?

  • Legen Sie Ihr Budget und Ihren Zeitraum fest
  • Skizzieren Sie Ihr Angebot
  • Bekommen Sie Geld für Ihre Arbeit

Heuern Sie Freelancer an, die auch auf dieses Projekt geboten haben

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online