I have a paid version of WinSCP from the Microsoft App Store. How do I use this to implement in VBA?
If I follow the instructions on your Downloading and Installing WinSCP .NET Assembly page, does this mean I would have to manually keep updating the files when there are updates?
Sorry if I am now mixing topics, but I want to explain why I wish to use VBA.
Currently, I am using WinSCP to sync local files/folders to my website server. Some files are updated often and need to be uploaded immediately. Many files are generated by Excel VBA. This mostly all works fine. However, occasionally, one my critical files gets uploaded with 0 KB size. I think this is due to a loss of connection during the upload for some reason. When this happens, WinSCP does not detect an error and does not try to upload the file again. I see that others have reported this in the forum, but I couldn't find an obvious resolution. So I want to use VBA to check for this situation and correct it if it happens.
Can you please suggest any easy way to do this?
Any guidance you can provide would be really appreciated.