Help with variable / run in script.......

[mikeshan1784]

To anyone that can help,

I have the following script.

strFROMDIR = "E:\DOWNLOAD DATA\"
strTODIR = "W:\DataExchange\DataSync\"
strTOARC = "E:\DataExchange\DataSync\Archive\"
strTRIGDIR = "E:\DataExchange\Trigger\"
strUSERDIR = "C:\Onc\Sync\"
strUSERS = InputBox("Enter The Users Name:&quot
strTABLES = "ALL"
strGROUPA = "osql -U FameADM -P FameADM -d OnContactDB -Q "SPFM_Sync_GroupA " & USERS & ", " & TABLES & ", " & TODIR & ", " & USERDIR & "" -w 130 -S PNTSQL1.fic.com -n -o E:\Batlib\Reports\SPFM_Sync_GroupA_Prod.Rpt"
WSHShell.Run " & strGROUPA & ", 1, False

When I run this I get an expected end of statement error. I understand that it is because of the " right after -Q in the "strGROUPA = " setup but for this osql command the extra quotes are needed. Does anyone know how to set this up so that I can include the "" in the variable. I have also tried this osql command line with WSHShell.Run and I get the same error. Any help is appreciated...

Thanks in advance,
Mike Shanley

 

[JustinEzequiel]

try something like this

[tt]strNAME = "Justin"
strMSG = "Hello"

MsgBox strNAME & " said """ & strMSG & """."[/tt]