Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

VBS using LIKE to compare strings "Sub or Function not defined"

Tags:

vbscript

I'm trying to make a script to connect a network printer to a user computer. The script uses the computer name who needs the printer as a parameter.

Printers names are similar their printserver name, eg. server_USA has printers like printer_USA01, printer_USA02.

But it's throwing the error "Sub or Function not defined" when arrives at the first like... why ?

Set shl = WScript.CreateObject("WScript.Shell")
strName = Wscript.Arguments.Item(0)

'input Printer name
strPrinter = InputBox("Please enter share name of printer to install:", _
    "Add network printer")

if strPrinter = "" then
    msgbox "Can't be empty."
    WScript.quit

elseif strPrinter Like "printer_USA*" then
    strServer = server_USA

elseif strPrinter Like "printer_SPAIN*" then
    strServer = server_SPAIN

else
    'Printer name NOT registered, input printserver manually:
    strServer = inputbox("Please enter the name of the printserver","printserver")

    if strServer = "" then
        msgbox "Can't be empty."
        WScript.quit
    End if

End if

'ADD
shl.run "RUNDLL32 PRINTUI.DLL,PrintUIEntry /ga /c\\" & strName & " /n\\" & strServer & "\" & strPrinter
like image 301
pedaleo Avatar asked Dec 25 '22 19:12

pedaleo


1 Answers

there is no Like operator in VBScript. You could use Instr.

if strPrinter = "" then
    msgbox "Can't be empty."
    WScript.quit

elseif Instr( 1, strPrinter, "printer_USA", vbTextCompare ) > 0 then
    strServer = server_USA

The vbTextCompare constant ( value=1) is used to Perform a textual comparison

like image 83
rene Avatar answered Jan 14 '23 12:01

rene