Iâm getting an error when trying to run this VBscript.
Script: (the pathname of the script)
Error: type mismatch: âformatâ
Source: Microsoft vbscript runtime error
Iâve used several .vbs FTP scripts before with no problem, but whatâs new/different with this one is that the Upload filename is not static, itâs
L(the current date in mmddyy format)t
This VBscript is being invoked from some VB
6.0 , Iâve used statements like:
DestinationFile = "D:\BD\HT\NewBusiness\HT" & Format(Date, "mmddyy") & ".txt"
all the time without problem.
My question is:
What format do I need to make the .Upload statement in the .vbs to get it to work
Or if thatâs not what needs to be done
Is there a way to pass via variables from vb
6.0 to vbscript the names of the two files to use in the upload statement, so I pass in the L020707t name + the path needed?
Thanks in advance,
' VBS Script Generated by CuteFTP (TM) macro recorder.
' Generated, then edited: 02/07/07 by dgr
' Create TEConnection object
Set MySite = CreateObject("CuteFTPPro.TEConnection")
' Initialize remote server host name, protocol, port, etc.
MySite.Host = "ftp.letterlogc.com"
MySite.Protocol = "FTP"
MySite.Port = 21
MySite.Retries = 34
MySite.Delay = 7
MySite.MaxConnections = 4
MySite.TransferType = "ASCII"
MySite.DataChannel = "DEFAULT"
MySite.AutoRename = "OFF"
' WARNING!!! SENSITIVE DATA: user name and password.
MySite.Login = "*******"
MySite.Password = "*******"
MySite.SocksInfo = ""
MySite.ProxyInfo = ""
' Connect to remote server
MySite.Upload "D:\DailyLetterRun&RSFUploads\Letters\L" & Format(Date, "mmddyy") & "t", "/L" & Format(Date, "mmddyy") & "t"