Develop VBA tool to send file via SFTP

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.

Skills: Excel, Software Architecture, Visual Basic for Apps

See more: vba upload file sftp, vba code upload file sftp, software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, j2me file http send, oscommerce file server send email, software write book images, software write books, find latest file creation date folder vba, send csv vba msaccess, send fax vba, software write protection, free software write book, automatic send mail vba, file upload send email php progress, save file todays date excel vba, software write book, transfer file sftp php, vba outlook freelancer support

About the Employer:
( 3 reviews ) Shrewsbury, United Kingdom

Project ID: #11816463

Awarded to:


This error is because you're using older version of Excel which does not support "OpenTextFile". This can be easily changed so it will work on older versions also. It will be good if I can try access your sftp server, More

£12 GBP / hour
(26 Reviews)

14 freelancers are bidding on average £12/hour for this job


Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among More

£15 GBP / hour
(488 Reviews)

Hi, I am good at Excel vba tools. Please provide me the state where it is standing and see if i can crack the error. Looking forward to discuss further in the chat.

£15 GBP / hour
(516 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

£10 GBP / hour
(185 Reviews)

"**** Reliable freelancer & 24 X 7 communication [login to view URL] from SB IT Services ****.I have read your description and can complete in 2 days and agree that I can complete tasks with high quality and consistency.W More

£10 GBP / hour
(171 Reviews)

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more program and SFTP details so that I can estimate cost and time better. I have completed more than 280 p More

£15 GBP / hour
(148 Reviews)

Hi, I have read the project and understand your requirement. I did many work like this with my financial and excel competency. I am a highly trained on Excel and VB Macros. I did any project regarding automated yahoo More

£13 GBP / hour
(81 Reviews)

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with vari More

£13 GBP / hour
(35 Reviews)

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec More

£10 GBP / hour
(32 Reviews)

Hello, I reviewed the job posting extremely carefully and I can develop VBA tool to send file via SFTP. You can get hold of me instantly to discuss this position further. I am available via. Skype, E-mail, Whatsa More

£12 GBP / hour
(7 Reviews)

Hi, I can help you solve the issue if getting hired. Look forward to working with you soon. Best Regards,

£10 GBP / hour
(9 Reviews)

Hello sir, I understand that you are looking for a Website. I'll be happy to work on this project. I have few questions, please come on chat for further discussion. I worked for 7 years with a big IT company and no More

£13 GBP / hour
(5 Reviews)

I have already implemented the same thing in PowerShell in one of the project, you can check my reviews for the same type of project. windows do not support sftp therefore winscp is must.

£13 GBP / hour
(3 Reviews)

Hello Sir/Mam, Me And My Employees are Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. If you are looking for data entry or search work as you More

£12 GBP / hour
(0 Reviews)