can you share your complete code??
Before posting, please read how to report bug or request support effectively.
Bug reports without an attached log file are usually useless.
I am trying to use WinSCP in an Excel VBA environment. I've been able to get it working okay on a PC with Windows 7, Excel 2007 and WinSCP version 5.1.7. However when I used the same VBA code in Excel 2007 on a PC with Windows 8 32 bit, I get an automation error the moment I start to use WinSCP, i.e.
Dim mySession As New Session
' Enable custom error handling
On Error Resume Next
The subroutine "Upload" is the same as the VBA example given in the web pages. This command immediately throws the "Automation Error".
I've tried uninstalling it and installing the latest beta version 5.2.4, running regasm.exe to create and register the tlb file, but I get the same Automation Error.