+ Reply to Thread
Results 1 to 2 of 2

How to Change Excel Marco upload from FTP to SFTP?

  1. #1
    Registered User
    Join Date
    09-27-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    17

    How to Change Excel Marco upload from FTP to SFTP?

    I used the following VBA code in Excel Marco togther with the Script code in Uploading CSV file through FTP server, Workes fine.

    Shell "ftp -v -i -s:C:\Script\scriptST1.ftp mydomain.com"

    But now the Server changed from FTP to SFTP (secured).

    Should i simply change to the following by Adding "S" to" FTP"?
    ie.
    Shell "Sftp -v -i -s:C:\Script\scriptST1.Sftp mydomain.com"???

    Thanks for your help.

  2. #2
    Valued Forum Contributor smuzoen's Avatar
    Join Date
    10-28-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    610

    Re: How to Change Excel Marco upload from FTP to SFTP?

    If you are going to be using SFTP there will probably be requirements for usernames, passwords and keys. Take a look at WinSCP - it is free and easy to script. The documentation on the website is excellent. The link is http://winscp.net/eng/index.php
    Hope this helps.
    Anthony
    Pack my box with five dozen liquor jugs
    PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1