Check result of pscp transfer in VBA

Question

I use pscp to copy a file from Windows to Unix and I run it using VBA. After pscp command how will I ensure that file is transferred successfully?

shell "pscp -P 22 -pw abcd test.csv user@XXX.com:/u01/test"

Answer 1

Test pscp exit code. 0 is success, 1 is error.

For examples of code that test exit code of an application, see:

• How to catch Windows shell script errors launched from VBA code?
• VBA Shell and Wait with Exit Code