VBA Error - Reflection.FTP.3

See more:

MS-Excel

VBA

FTP

I had this error pop up on exactly the 3rd line of code below. There seem to be no explanation on the Internet for this behaviour.

I'm looking at why this error came up, and fixed itself after few minutes.

Set Ftp = CreateObject("Reflection.FTP.3")
Ftp.Open "xxx.xxx.xxx.xxx", "username", "password"
Ftp.SetCurrentDirectory "DirectoryName/DirectoryName/DirectoryName"

What was the error?

Run-time error '-2147418113 (8000ffff)': Method 'SetCurrentDirectory' of object 'IReflectionFTP' failed

More details:

Application: Excel Macro

Language : VB (VBA)

*Is this because of a coding error? *

Not likely. The macro has been long running and this came up for the first time.

*Is it because of a FTP service disruption? *

May be. But logs have a recording for every second and there seems to be no outage.