Question Using a vb script

J Trahair

Well-known member
Joined
May 14, 2008
Messages
175
Location
Spain
Programming Experience
10+
Hi. I have a script which I want to run from VB.net. It is a sample script, so if this works I can use a 'real' one. The whole script appears below. However, all instances of the word 'Set' automatically disappear as soon as they can. This means that those variables are not Dim'med.

Even if I Dim them, this is not the same as 'Set '. Lastly, it says WScript is not declared.

Have I missed an Import or Inherit?

'Chilkat' is a component which is installed on my system, but I'm not sure how to relate it to the code.

Thank you.

VB.NET:
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.txt", True)


set http = CreateObject("Chilkat.Http")

'  Any string unlocks the component for the 1st 30-days.
success = http.UnlockComponent("Anything for 30-day trial")
If (success <> 1) Then
    MsgBox http.LastErrorText
    WScript.Quit
End If

'  This example uses a live web service at:
'  http://www.webservicex.net/uklocation.asmx
'  It gets the UK town,Postcode and County by Postcode(First Section of Post Code)

'  The SOAP XML will look like this:
'  <?xml version="1.0" encoding="utf-8"?>
'  <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
'    <soap:Body>
'      <GetUKLocationByPostCode xmlns="http://www.webserviceX.NET">
'        <PostCode>string</PostCode>
'      </GetUKLocationByPostCode>
'    </soap:Body>
'  </soap:Envelope>

'  For this example's sake, we'll load the XML from a file.  We'll test using PostCode "E3".
'  The SOAP XML for this example may be downloaded from:
'  http://www.chilkatsoft.com/testData/ukPostCodeSoap.xml
set xml = CreateObject("Chilkat.Xml")
success = xml.LoadXmlFile("ukPostCodeSoap.xml")
If (success <> 1) Then
    MsgBox xml.LastErrorText
    WScript.Quit
End If

strXml = xml.GetXml()

'  We'll need to add this in the HTTP header:
'  SOAPAction: "http://www.webserviceX.NET/GetUKLocationByPostCode"
http.SetRequestHeader "SOAPAction","http://www.webserviceX.NET/GetUKLocationByPostCode"

'  Some services expect the content-type in the HTTP header to be "application/xml" while
'  other expect text/xml.  The default sent by Chilkat is "application/xml", but this web service
'  expects "text/xml".  Therefore, change the content-type:
http.SetRequestHeader "Content-Type","text/xml; charset=utf-8"

'  The endpoint for this soap service is:
endPoint = "http://www.webservicex.net/uklocation.asmx"

'  Note: This particular web service was live and functioning at the time this example
'  was written.  It is possible that as time progresses, this web service will no longer
'  be availble...
' resp is a Chilkat.HttpResponse
Set resp = http.PostXml(endPoint,strXml,"utf-8")
If (resp Is Nothing ) Then
    outFile.WriteLine(http.LastErrorText)

    outFile.WriteLine("LastHeader:")
    outFile.WriteLine(http.LastHeader)
Else

    responseStatusCode = resp.StatusCode
    '  You may wish to verify that the responseStatusCode equals 200...
    outFile.WriteLine("Response Status Code: " _
         & responseStatusCode)

    '  You may examine the exact HTTP header sent with the POST like this:
    outFile.WriteLine("LastHeader:")
    outFile.WriteLine(http.LastHeader)

    '  Examine the XML returned by the web service:
    outFile.WriteLine("XML Response:")
    set xmlResp = CreateObject("Chilkat.Xml")
    success = xmlResp.LoadXml(resp.BodyStr)
    '  Assume the LoadXml is successful...
    '  Get rid of the SOAP wrappings and get to the meat of this particular response.
    '  The TagContent method returns the content of the 1st node in the XML document
    '  having a specific tag:

    unwrappedXml = xmlResp.TagContent("GetUKLocationByPostCodeResult")
    outFile.WriteLine(unwrappedXml)

    '  The unwrapped XML could be loaded into an XML object and parsed...
    set xmlMeat = CreateObject("Chilkat.Xml")
    success = xmlMeat.LoadXml(unwrappedXml)

    '  ...
End If


outFile.Close
 

cjard

Well-known member
Joined
Apr 25, 2006
Messages
7,059
Programming Experience
10+
Hi. I have a script which I want to run from VB.net. It is a sample script, so if this works I can use a 'real' one. The whole script appears below.

Do you mean you want to convert VBScript to vb.net code, or do you mean that you want to make your app have scripting support?
 

J Trahair

Well-known member
Joined
May 14, 2008
Messages
175
Location
Spain
Programming Experience
10+
I want my app to have scripting support. I have tried doing this direct in VB.NET using a 3rd party component (which doesn't work - even the Support person gave up).

However, if you know how to do this in VB.NET, please let me know, and I will abandon the vb scripting route.
 

JohnH

VB.NET Forum Moderator
Staff member
Joined
Dec 17, 2005
Messages
15,617
Location
Norway
Programming Experience
10+
You should be able to add a reference to this COM library and use the objects and their methods in VB code, for example this:
VB.NET:
set http = CreateObject("Chilkat.Http")
translates to:
VB.NET:
Dim http As New Chilkat.Http
.Net has good file system support, for example:
VB.NET:
Dim writer As New IO.StreamWriter("filename.txt")
writer.WriteLine("hello")
writer.Close()
 

cjard

Well-known member
Joined
Apr 25, 2006
Messages
7,059
Programming Experience
10+
and it has good web service support - WSDL.exe can create you some stub classes for your web service
 

wizzardmr42

Well-known member
Joined
Mar 15, 2008
Messages
90
Location
England
Programming Experience
10+
The Chilkat components are available for .NET as well - there isn't much point in using the COM version in .NET

I think you can add a reference to the old COM Microsoft Script Control and do it via that, but I haven't used it for years and I don't recall the precise name.
 

JohnH

VB.NET Forum Moderator
Staff member
Joined
Dec 17, 2005
Messages
15,617
Location
Norway
Programming Experience
10+
and it has good web service support - WSDL.exe can create you some stub classes for your web service
For interaction with web service I'd prefer this too, just add a web reference to the asmx service path and it will create the proxy classes to use. J Trahair mentioned "It is a sample script, so if this works I can use a 'real' one." though, so I don't know if Chilkat is needed for that.

If I'm not misunderstanding the purpose with this, you can also run the scripts from VB, if it can be started from Explorer/shortcut you can also run it with Process.Start.
 
Top Bottom