The following script runs in PS IDE correctly (identifying info has been changed to generics):
C:\Lena\WinSCP\WinSCP.com /command 'open ftp://user:pw@sitename.com' 'put ""W:\Master_Library\BUILDERS\WOODSIDE HOMES\THE OVERLOOK\28855.348\28855.348_Rough.PDF"" /sitename.com/Content/PickTicks/' 'exit'
The issue becomes just how many quotes do I need to get this same script to run in a VBA Shell call.
Call Shell( _
"C:\Lena\WinSCP\WinSCP.com /command " & _
"""open ftp://user:pw@sitename.com/"" " & _
"""put """" & RootTarget & """" /sitename.com/Content/PickTicks/"" " & _
"""exit""")
You can see I currently have “”“” on each side of the variable holding that path - I have tried a couple of different things including single quotes but nothing seems to be working.