FTP via VBA works except for the end of the file being downloaded gets cut off

[Mistux-M]

So I am using the code for FTP from this thread

https://www.tek-tips.com/viewthread.cfm?qid=1703957

(now closed) which works perfect, except that on downloads the last few characters or lines gets cut off, it is not consistent.

I'm using the latest MS Access (Office 365 or whatever they call it now) and Windows 10, 64 bit.

Not sure what to make of that, and just looking for suggestions as I have racked my brain out going through the code to see what might be causing it. Anyone have experience with that code and/or can suggest different code to use. (I have looked but seems like FTP code examples died off a while ago.)

Anyway, thanks.

Mitch

 

[combo]

260 is the limit for ANSI version. You can try FtpFindFirstFileW function instead. For similar FindFirstFileW: "In the ANSI version of this function, the name is limited to MAX_PATH characters. To extend this limit to 32,767 wide characters, call the Unicode version of the function and prepend "\\?\" to the path." (

https://docs.microsoft.com/en-us/windows/win32/api/fileapi/nf-fileapi-findfirstfilew)

combo

 

[strongm]

>using the code for FTP

Which bit - mine or 1DMFs?

And code for getting the list, or code for GETting a file (or files)?