So we have successfully uploading a file using MS Access VBA and WinSCP. The issue is that we want to be able to validate that the file processed correctly in the Unix server. There are two other folders on the server, one called errored and one called completed. When the file is processed, it will be moved to one of those folders depending on whether the server application successfully processed it or not. Is there a way through WinSCP scripting to be able to view the folder contents in Access using VBA? Or any other way of validation for that matter?
I'm a noob when it comes to this so any help is greatly appreciated.