+ Reply to Thread
Results 1 to 2 of 2

Suddenly VBA to run ftp command not work.

  1. #1
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    Suddenly VBA to run ftp command not work.

    Dear Experts,

    For 5 months, I use to run this VBA without fail :
    Please Login or Register  to view this content.
    where the ftp.txt is like this :
    Please Login or Register  to view this content.
    Until two days ago, suddenly the cmd window show error:
    425 Could not open data connection to port XXXXX: Connection refused

    as shown in the image below:
    ACDSee_2021-04-04_17-09-12.png

    The result, in the file manager of my cpanel, DarmaPangan.csv has zero byte.

    But the strange thing, if I :
    1. open the cmd window
    2. call the ftp.exe
    3. type in the cmd windows line by line (the same line in ftp.txt)
    it can connect to the port then upload the file. As seen in the image below:
    cmd_2021-04-04_17-15-15.png

    My question :
    What is the cause the error which happen suddenly like that ?
    Is there a way which I should change the VBA line in order it can connect to the port ?

    Any kind of help would be greatly appreciated.
    Thank you in advanced.
    Last edited by karmapala; 04-04-2021 at 05:25 AM.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Suddenly VBA to run ftp command not work.

    I would suggest using the full path for cd. e.g.
    cd /pub/darmapangan

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy tab within Excel - suddenly won't work!
    By Jexcel2012 in forum Excel General
    Replies: 4
    Last Post: 08-02-2012, 04:57 PM
  2. How can AutoFilter suddenly not work?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2011, 08:58 AM
  3. Index formulas suddenly don't work
    By FortuneSyn in forum Excel General
    Replies: 5
    Last Post: 05-03-2010, 04:50 PM
  4. Vlookup doesn't work suddenly
    By associates in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2008, 08:55 PM
  5. Button suddenly does not work
    By Man Utd in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-20-2005, 02:05 AM
  6. beep suddenly won't work
    By Jack Sons in forum Excel General
    Replies: 3
    Last Post: 08-14-2005, 10:05 AM
  7. [SOLVED] Find and Replace dialog box in VBA doesn't work suddenly
    By Leung in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2005, 03:07 AM

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