Mostly I just end up pulling up the winscp.com prompt after all this. I have a million iterations of trying to get it to work. I'm trying to do this in VBA which is probably where I fall down. Goal is to SFTP a file everynight after a bunch of macros finish running in excel which is why I chose to house it in VBA.
Shell ("""C:\Program Files (x86)\WinSCP\WinSCP.com"" /ini=nul ""/script=c:\Users\John Doe\Desktop\RCGWM1.txt""")
Any help would be greatly appreciated. Like i said, most of my iterations just open up winscp.com command prompt and I can get it to logon but then they don't execute anything.