Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default In need of VB some assistance


Here's what I have:

Sub TEST_GetDetailFaxStatus()

Dim testgetdetailfaxstatus As clsGetDetailFaxStatusXML
Dim testsampleparser As clsSampleParserXML

Set testgetdetailfaxstatus = New clsGetDetailFaxStatusXML
Set testsampleparser = New clsSampleParserXML

'replace the values here with the proper account number and transaction
ID

Debug.Print
testsampleparser.parseDocument(testgetdetailfaxsta tus.SendRequest("accountnumber",
"password", "false", "", "", "", "", ""))

Debug.Print "Error Flag: " &
testsampleparser.GetNodeValue("/GetDetailFaxStatusResponse/GetDetailFaxStatusResult/Header/ErrorFlag")
Debug.Print "Transaction ID: " &
testsampleparser.GetNodeValue("/GetDetailFaxStatusResponse/GetDetailFaxStatusResult/FaxDetail/TransactionID")

End Sub


And this is what else I have:

Option Explicit

Function SendRequest(ParamArray arglist()) As String

Dim pArray() As HashRecord
Dim i As Integer
Dim strKeys
Dim responseHeaders
Dim responseBody
Dim lastError

strKeys = Array("UserID", "UserPassword", "AllUsersFlag",
"BillingCodeFilter", "TransactionIDListFilter", "StartTimeStampFilter",
"EndTimeStampFilter", "FaxNumbersListFilter")

ReDim pArray(UBound(strKeys))

For i = 0 To UBound(arglist)
With pArray(i)
..strValue = arglist(i)
..strKey = strKeys(i)
End With
Next i

responseHeaders = Null
responseBody = Null
Set oXMLHttp = Nothing

InitializeServiceArrays

On Error Resume Next

If (accessWebService(strGetDetailFaxStatus, pArray())) Then
responseHeaders = oXMLHttp.getAllResponseHeaders()
responseBody = oXMLHttp.responsetext
SendRequest = responseBody
Else
lastError = "sendRequest: error initializing the socket."
SendRequest = ""
End If
If Not (Err = 0) Then
lastError = "sendRequest: unknown error occurred during the request."
SendRequest = ""
End If

End Function


--
alexm999
------------------------------------------------------------------------
alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918
View this thread: http://www.excelforum.com/showthread...hreadid=517986

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need assistance VROSARIO7 Excel Worksheet Functions 1 July 6th 09 08:43 PM
VBA Assistance Elcobar Excel Discussion (Misc queries) 2 June 15th 09 02:45 AM
Need some assistance N Schei Charts and Charting in Excel 2 March 24th 05 07:58 PM
Assistance in VBA Joe Excel Programming 1 September 1st 04 04:35 PM
I need assistance please Joe[_29_] Excel Programming 5 January 5th 04 04:46 PM


All times are GMT +1. The time now is 02:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"