I tried to use your code for access.
at the position mysession.open mysesssionoptions a get an error:
the winscp.exe executable was not found at location of the assembly (c:\windows\system32), nor in an installation path. you may use session.executablepath property to explicitly set path to winscp.exe.
I have no idea to use the session.executable property in my vba code!
Please can you help me?