locked
Help FTP RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all

    I have an access database which makes CSV file that should be uploaded on a remote FTP server.

    I need to make automated process to upload a file using command prompt (which I access through VBA shell).

    Issues:

    • I can access internet only via proxy
    • The port for FTP Server is different from the standard

    Any help is highly appreciated!

    Thank you!

    João

    Wednesday, April 24, 2013 5:46 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    IE uses the wininet.dll.  You can access this DLL using win32 commands.  I have used it a lot.  It is very reliable and it is already on the PC.  It allows you to specify a port and a proxy.  Take a look at:

    http://www.codeproject.com/Questions/321083/Automatic-FTP-via-Excel-VBA-Macro

    Thursday, April 25, 2013 1:44 AM