使用vbs获取雅虎汇率

Function bytes2bstr(vin)
  strreturn = ""
  for i = 1 to lenb(vin)
    thischarcode = ascb(midb(vin,i,1))
    if thischarcode < &h80 then
      strreturn = strreturn & chr(thischarcode)
    else
      nextcharcode = ascb(midb(vin,i+1,1))
      strreturn = strreturn & chr(clng(thischarcode) * &h100 + cint(nextcharcode))
      i = i + 1
    end if
  next
  bytes2bstr = strreturn
End Function
Function GetURL(url)
  Set Retrieval = CreateObject("Microsoft.XMLHTTP")
  With Retrieval
    .Open "GET", url, False
    .Send
    GetURL = bytes2bstr(.responsebody)
    if len(.responsebody)<2 then
      strContent = "远程通讯故障!"
      Call LogToFile(strContent,1)
    response.end
    end if
  End With
  Set Retrieval = Nothing
End Function
'========以上为自定义函数========
 
s1 = INPUTBOX("原始货币代码:","请输入原始货币代码","USD")
s2 = INPUTBOX("目标货币代码:","请输入目标货币代码","CNY")
s = s1&s2
url = "http://download.finance.yahoo.com/d/quotes.csv"&s&"=x"
if s1<>"" and s2<>"" Then
  huilv = GetURL(url)
  MsgBox huilv
End if

标签:
vbs,获取雅虎汇率

免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
狼山资源网 Copyright www.pvsay.com

评论“使用vbs获取雅虎汇率”

暂无“使用vbs获取雅虎汇率”评论...