WSDL描述http://www.xmethods.net/sd/CurrencyExchangeService.wsdl以下是获取汇率的函数。Public Function GetXchangeRate(ByVal strCountry1, _
ByVal strCountry2) ' As String
On Error Resume Next
' SOAP Function
Dim WSDL_URL 'As String
WSDL_URL = "http://www.xmethods.net/sd/CurrencyExchangeService.wsdl"
Dim objSOAPClient
Dim strResult 'As String
Set objSOAPClient = CreateObject("MSSOAP.SoapClient")
objSOAPClient.ClientProperty("ServerHTTPRequest") = True
objSOAPClient.mssoapinit WSDL_URL
strResult = objSOAPClient.GetRate(CStr(strCountry1), _
CStr(strCountry2)) ' As String If Err <> 0 Then
GetXchangeRate = "ERROR: Could Not Get Exchange Rate (Error # " & CStr(Err.Number) & " " & Err.Description & " in " & Err.Source & ")"
'GetXchangeRate = "ERROR"
Set objSOAPClient = Nothing
Err.Clear
Exit Function
End If
Set objSOAPClient = Nothing
GetXchangeRate = strResult
End Function
ByVal strCountry2) ' As String
On Error Resume Next
' SOAP Function
Dim WSDL_URL 'As String
WSDL_URL = "http://www.xmethods.net/sd/CurrencyExchangeService.wsdl"
Dim objSOAPClient
Dim strResult 'As String
Set objSOAPClient = CreateObject("MSSOAP.SoapClient")
objSOAPClient.ClientProperty("ServerHTTPRequest") = True
objSOAPClient.mssoapinit WSDL_URL
strResult = objSOAPClient.GetRate(CStr(strCountry1), _
CStr(strCountry2)) ' As String If Err <> 0 Then
GetXchangeRate = "ERROR: Could Not Get Exchange Rate (Error # " & CStr(Err.Number) & " " & Err.Description & " in " & Err.Source & ")"
'GetXchangeRate = "ERROR"
Set objSOAPClient = Nothing
Err.Clear
Exit Function
End If
Set objSOAPClient = Nothing
GetXchangeRate = strResult
End Function
MsgBox GetXchangeRate("usa", "china")
End Sub
Public Function GetXchangeRate(ByVal strCountry1, _
ByVal strCountry2) ' As String
'On Error Resume Next
' SOAP Function
Dim WSDL_URL 'As String
WSDL_URL = "http://www.xmethods.net/sd/CurrencyExchangeService.wsdl"
Dim objSOAPClient As New MSSOAPLib30.SoapClient30
Dim strResult 'As String
'Set objSOAPClient = CreateObject("MSSOAP.SoapClient") objSOAPClient.ClientProperty("ServerHTTPRequest") = True
objSOAPClient.MSSoapInit WSDL_URL
strResult = objSOAPClient.GetRate(CStr(strCountry1), _
CStr(strCountry2)) ' As String If Err <> 0 Then
GetXchangeRate = "ERROR: Could Not Get Exchange Rate (Error # " & CStr(Err.Number) & " " & Err.Description & " in " & Err.Source & ")"
'GetXchangeRate = "ERROR"
Set objSOAPClient = Nothing
Err.Clear
Exit Function
End If
Set objSOAPClient = Nothing
GetXchangeRate = strResult
End Function
http://www.microsoft.com/downloads/details.aspx?familyid=c943c0dd-ceec-4088-9753-86f052ec8450&displaylang=en
strCountry2) As String
'On Error Resume Next
' SOAP Function
Dim WSDL_URL As String
Dim objSOAPClient As SoapClient30
Dim strResult 'As String
Dim a1, a2
a1 = strCountry1
a2 = strCountry2
WSDL_URL = "http://www.xmethods.net/sd/CurrencyExchangeService.wsdl"
Set objSOAPClient = New SoapClient30
objSOAPClient.ClientProperty("ServerHTTPRequest") = True
objSOAPClient.mssoapinit WSDL_URL
strResult = objSOAPClient.GetRate(a1, a2) ' As String If Err <> 0 Then
GetXchangeRate = "ERROR: Could Not Get Exchange Rate (Error # " & CStr(Err.Number) & " " & Err.Description & " in " & Err.Source & ")"
'GetXchangeRate = "ERROR"
Set objSOAPClient = Nothing
Err.Clear
Exit Function
End If
Set objSOAPClient = Nothing
GetXchangeRate = strResult
End Function
albania
algeria
andorra
andorra
angola
argentina
aruba
australia
austria
bahrain
bangladesh
barbados
belgium
belize
bermuda
bhutan
bolivian
botswana
brazil
england
united kingdom
uk
great britain
brunei
burundi
cambodia
canada
cape verde
cayman islands
chile
china
colombia
comoros
costa rica
croatia
cuba
cyprus
czech republic
den
dijibouti
dominican republic
netherlands
east caribbean
ecuador
egypt
el salvador
estonia
ethiopia
euro
falkland islands
fiji
finland
france
gambia
germany
ghana
gibraltar
greece
guatemala
guinea
guyana
haiti
honduras
hong kong
hungary
iceland
india
indonesia
iraq
ireland
israel
italy
jamaica
japan
jordan
kazakhstan
kenya
korea
kuwait
laos
latvia
lebanon
lesotho
liberia
libya
lithuania
luxembourg
macau
macedonia
malaga
malawi kwacha
malaysia
maldives
malta
mauritania
mauritius
mexico
moldova
mongolia
morocco
mozambique
myanmar
namibia
nepal
new Zealand
nicaragua
nigeria
north korea
norway
oman
pakistan
panama
papua new guinea
paraguay
peru
philippines
poland
portugal
qatar
romania
russia
samoa
sao tome
saudi arabia
seychelles
sierra leone
singapore
slovakia
slovenia
solomon islands
somalia
south africa
spain
sri lanka
st helena
sudan
suriname
swaziland
sweden
switzerland
syria
taiwan
tanzania
thailand
tonga
trinidad
tunisia
turkey
united states
us
usa
uae
united arib emirates
uganda
ukraine
uzbekistan
vanuatu
venezuela
vietnam
yemen
yugoslavua
zambia
zimbabweGetXchangeRate的参数只能是这些字符串。
:)