Simple VBScript syntax error?

Advertisement

edflecko
Guest

Simple VBScript syntax error?

I have a really simple vbscript to run WinSCP that doesn't error...but it clearly doesn't run either.

Option Explicit
Dim objFSO
Dim objShell

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objShell = WScript.CreateObject( "WScript.Shell" )
objShell.Run """C:\Program Files\WinSCP\winscp.exe /console /command """ & """option batch abort""" & " " & """option confirm on""" & " " & """option transfer ascii""" & """open sftp://username:password@mycompany.com""" & """get textfile.txt C:\file\path\textfile.txt""" & " " & """close""" & " " & """exit"""

Wscript.Quit

What am I doing wrong?

Ed

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
41,442
Location:
Prague, Czechia

Re: Simple VBScript syntax error?

It's really an unnecessary mess with all those " and &.
Anyway, you are definitely missing a space between the "open transfer ascii" and "open..." commands as well as between "open..." and "get...".

Also consider using WinSCP .NET assembly. Either via COM from VBScript or, if you do not need VBscript, using PowerShell instead:
https://winscp.net/eng/docs/library_com_wsh
https://winscp.net/eng/docs/library_powershell

Reply with quote

Advertisement

You can post new topics in this forum