{"id":2503,"date":"2012-12-20T13:54:02","date_gmt":"2012-12-20T04:54:02","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=2503"},"modified":"2013-08-19T14:13:44","modified_gmt":"2013-08-19T05:13:44","slug":"skydrive%e4%b8%8a%e3%81%ae%e3%83%95%e3%82%a9%e3%83%ab%e3%83%80%e3%83%bc%e3%81%8b%e3%82%89%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab%e3%82%92%e3%83%80%e3%82%a6%e3%83%b3%e3%83%ad%e3%83%bc%e3%83%89%e3%81%99","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=2503","title":{"rendered":"SkyDrive\u4e0a\u306e\u30d5\u30a9\u30eb\u30c0\u30fc\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308bVBScript"},"content":{"rendered":"

\u524d\u56de<\/a>\u306fSkyDrive API<\/a>\u3092\u5229\u7528\u3057\u3066\u30c9\u30e9\u30c3\u30b0&\u30c9\u30ed\u30c3\u30d7\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092SkyDrive\u4e0a\u306e\u30d5\u30a9\u30eb\u30c0\u30fc\u306b\u30a2\u30c3\u30d7\u3059\u308bVBScript\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u306f\u9006\u306bSkyDrive\u4e0a\u306e\u30d5\u30a9\u30eb\u30c0\u30fc\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308bVBScript\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n

\u203b Microsoft\u30a2\u30ab\u30a6\u30f3\u30c8\u3068API\u306e\u5229\u7528\u306b\u5fc5\u8981\u306a\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 ID\u306e\u53d6\u5f97\u65b9\u6cd5\u306f\u524d\u56de\u306e\u8a18\u4e8b<\/a>\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/span><\/p>\n

<\/p>\n

Option Explicit\r\n\r\nDim IE\r\nDim FlgIeQuit\r\nDim ParamGet\r\nDim AccessToken\r\nDim AuthenticationToken\r\nDim ExpiresIn\r\nDim DateExpires\r\n\r\n'---------------------------------------------------------------------\r\n'\u203b \u8981\u5909\u66f4\r\n'---------------------------------------------------------------------\r\nConst FOLDER_NAME = "\u30b5\u30f3\u30d7\u30eb\u30d5\u30a9\u30eb\u30c0\u30fc"\r\n'\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 ID\r\nConst CLIENT_ID = "****************"\r\n'\u30ea\u30c0\u30a4\u30ec\u30af\u30c8 \u30c9\u30e1\u30a4\u30f3(API\u8a2d\u5b9a\u3067\u81ea\u5206\u3067\u30c9\u30e1\u30a4\u30f3\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u306e\u307f\u5909\u66f4)\r\nConst REDIRECT_URL = "https:\/\/oauth.live.com\/desktop"\r\n'---------------------------------------------------------------------\r\n\r\nInit '\u521d\u671f\u5316\r\nDownloadSkyDriveFile\r\nMsgBox "\u51e6\u7406\u304c\u7d42\u4e86\u3057\u307e\u3057\u305f\u3002", 64 + 4096\r\n\r\nPrivate Sub Init()\r\n'\u5404\u5909\u6570\u521d\u671f\u5316\r\n  FlgIeQuit = 0\r\n  ParamGet = ""\r\n  AccessToken = ""\r\n  AuthenticationToken = ""\r\n  ExpiresIn = ""\r\n  DateExpires = ""\r\nEnd Sub\r\n\r\nPrivate Sub DownloadSkyDriveFile()\r\n'SkyDriveFile\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\r\n  Dim filePath\r\n  Dim filesInfo\r\n  Dim idFolder\r\n  Dim v, vv\r\n  Dim i\r\n  \r\n  If (DateExpires <> "") And (Now() < DateExpires) Then\r\n  Else\r\n    AuthenticateSkyDrive '\u8a8d\u8a3c\r\n  End If\r\n  If AccessToken = "" Then\r\n    MsgBox "\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u306e\u53d6\u5f97\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002", 16 + 4096\r\n    Exit Sub\r\n  End If\r\n  \r\n  '\u30d5\u30a9\u30eb\u30c0\u30fc\u306e\u78ba\u8a8d\r\n  idFolder = GetSkyDriveFolderId(AccessToken, FOLDER_NAME)\r\n  If (idFolder = "NoFolder") Or (idFolder = "Err") Or Len(idFolder) < 1 Then\r\n    MsgBox "SkyDrive\u30d5\u30a9\u30eb\u30c0\u30fc\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002", 16 + 4096\r\n    Exit Sub\r\n  End If\r\n  \r\n  '\u30d5\u30a1\u30a4\u30eb\u306e\u78ba\u8a8d\r\n  filesInfo = GetFilesInfo(AccessToken, idFolder)\r\n  If (filesInfo = "NoFile") Or (filesInfo = "Err") Or Len(filesInfo) < 1 Then\r\n    MsgBox "\u30d5\u30a1\u30a4\u30eb\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002", 16 + 4096\r\n    Exit Sub\r\n  End If\r\n  filePath = CreateObject("WScript.Shell").SpecialFolders("Desktop") & ChrW(92) '\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58\u5148:\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\r\n  v = Split(filesInfo, vbCrLf)\r\n  For i = LBound(v) To UBound(v)\r\n    vv = Split(v(i), ";")\r\n    DownloadFile filePath & vv(0), vv(1)\r\n  Next\r\nEnd Sub\r\n\r\nPrivate Sub AuthenticateSkyDrive()\r\n'SkyDrive\u8a8d\u8a3c\r\n  Dim url\r\n  Dim scope\r\n  Dim timeLimit\r\n  \r\n  Set IE = Nothing '\u521d\u671f\u5316\r\n  scope = "wl.skydrive_update wl.offline_access"\r\n  url = "http:\/\/oauth.live.com\/authorize?locale=ja&display=page&client_id=" & EncodeURL(CLIENT_ID) & "&scope=" & EncodeURL(scope) & "&response_type=token&redirect_uri=" & EncodeURL(REDIRECT_URL)\r\n  Set IE = WScript.CreateObject("InternetExplorer.Application", "IE_")\r\n  On Error Resume Next\r\n  With IE\r\n    .Visible = True\r\n    .Toolbar = False\r\n    .AddressBar = False\r\n    .MenuBar = False\r\n    .Top = 50\r\n    .Left = 200\r\n    .Width = 400\r\n    .Height = 500\r\n    .Navigate url\r\n    'While .Busy Or .readyState <> 4\r\n    '  WScript.Sleep 100\r\n    'Wend\r\n    timeLimit = DateAdd("s", 60, Now()) '\u30eb\u30fc\u30d7\u306e\u5236\u9650\u6642\u9593:60\u79d2\r\n    Do\r\n      WScript.Sleep 100\r\n      If FlgIeQuit = 1 Then Exit Do\r\n      If Now() > timeLimit Then Exit Do '\u5236\u9650\u6642\u9593\u3092\u904e\u304e\u305f\u3089\u30eb\u30fc\u30d7\u3092\u629c\u3051\u308b\r\n    Loop While ParamGet = ""\r\n    If FlgIeQuit = 0 Then .Quit\r\n  End With\r\n  If Err.Number <> 0 Then\r\n    MsgBox "\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f\u3002" & vbCrLf & "\u5185\u5bb9:" & Err.Description, 16 + 4096\r\n    Exit Sub\r\n  End If\r\n  On Error GoTo 0\r\n  If ParamGet = "" Then\r\n    MsgBox "\u30e6\u30fc\u30b6\u30fc\u8a8d\u8a3c\u306b\u5931\u6557\u3057\u307e\u3057\u305f\u3002", 16 + 4096\r\n    Exit Sub\r\n  End If\r\n  GetToken ParamGet\r\nEnd Sub\r\n\r\nPrivate Sub GetToken(ByVal param)\r\n'\u5404\u30c8\u30fc\u30af\u30f3\u53d6\u5f97\r\n  Dim v, vv\r\n  Dim i\r\n  \r\n  param = Replace(param, REDIRECT_URL & "#", "")\r\n  v = Split(param, "&")\r\n  For i = LBound(v) To UBound(v)\r\n    vv = Split(v(i), "=")\r\n    Select Case LCase(Trim(vv(0)))\r\n      Case "access_token": AccessToken = vv(1)\r\n      Case "expires_in": ExpiresIn = vv(1): DateExpires = DateAdd("s", CDbl(ExpiresIn), Now()) '\u30a2\u30af\u30bb\u30b9\u30c8\u30fc\u30af\u30f3\u306e\u6709\u52b9\u6642\u9593\u8a2d\u5b9a\r\n      Case "authentication_token": AuthenticationToken = vv(1)\r\n    End Select\r\n  Next\r\nEnd Sub\r\n\r\nPrivate Sub DownloadFile(ByVal filePath, ByVal url)\r\n'\u30d5\u30a1\u30a4\u30eb\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\r\n  Dim dat\r\n  Const adTypeBinary = 1\r\n  \r\n  On Error Resume Next\r\n  With CreateObject("Scripting.FileSystemObject")\r\n    If .FileExists(filePath) Then .DeleteFile filePath\r\n  End With\r\n  With CreateObject("MSXML2.XMLHTTP")\r\n    .Open "GET", url, False\r\n    .send\r\n    If .Status = 200 Then\r\n      dat = .responseBody\r\n      With CreateObject("ADODB.Stream")\r\n        .Type = adTypeBinary\r\n        .Open\r\n        .Write dat\r\n        .SaveToFile filePath\r\n        .Close\r\n      End With\r\n    Else\r\n      MsgBox "\u30d5\u30a1\u30a4\u30eb\u4fdd\u5b58\u51e6\u7406\u304c\u5931\u6557\u3057\u307e\u3057\u305f\u3002", 16 + 4096\r\n      Exit Sub\r\n    End If\r\n  End With\r\n  If Err.Number <> 0 Then Err.Clear: MsgBox "\u30d5\u30a1\u30a4\u30eb\u4fdd\u5b58\u51e6\u7406\u304c\u5931\u6557\u3057\u307e\u3057\u305f\u3002", 16 + 4096: Exit Sub\r\n  On Error GoTo 0\r\nEnd Sub\r\n\r\nPrivate Function GetSkyDriveFolderId(ByVal code, ByVal fn)\r\n'SkyDrive\u306e\u30d5\u30a9\u30eb\u30c0\u30fcID\u53d6\u5f97\r\n'\u30d5\u30a9\u30eb\u30c0\u30fc\u306a\u3057:NoFolder, \u30d5\u30a9\u30eb\u30c0\u30fc\u3042\u308a:id, \u30a8\u30e9\u30fc:Err\r\n  Dim ret\r\n  Dim js\r\n  Dim scr\r\n  Dim d\r\n  Dim elm\r\n    \r\n  js = "": ret = "NoFolder" '\u521d\u671f\u5316\r\n  On Error Resume Next\r\n  With CreateObject("MSXML2.XMLHTTP")\r\n    .Open "GET", "https:\/\/apis.live.net\/v5.0\/me\/skydrive\/files", False\r\n    .setRequestHeader "Authorization", "Bearer " & code\r\n    .send\r\n    If .Status = 200 Then js = .responseText\r\n  End With\r\n  If Len(js) > 0 Then\r\n    js = Replace(js, vbCr, "")\r\n    js = Replace(js, vbLf, "")\r\n    js = Replace(js, vbCrLf, "")\r\n    js = "(" & js & ")"\r\n    Set d = CreateObject("htmlfile")\r\n    Set elm = d.createElement("span")\r\n    elm.setAttribute "id", "result"\r\n    d.appendChild elm\r\n    scr = "var objects= eval('" & js & "').data;"\r\n    scr = scr & "for(var i in objects){"\r\n    scr = scr & "  if(objects[i].type=='folder' && objects[i].name=='" & fn & "'){"\r\n    scr = scr & "    document.getElementById('result').innerText=objects[i].id;"\r\n    scr = scr & "  }"\r\n    scr = scr & "}"\r\n    d.parentWindow.execScript scr\r\n    If Len(elm.innerText) > 0 Then ret = elm.innerText\r\n  End If\r\n  If Err.Number <> 0 Then Err.Clear: ret = "Err"\r\n  On Error GoTo 0\r\n  GetSkyDriveFolderId = ret\r\nEnd Function\r\n\r\nPrivate Function GetFilesInfo(ByVal code, ByVal id)\r\n'SkyDrive\u306e\u30d5\u30a1\u30a4\u30eb\u60c5\u5831(\u30d5\u30a1\u30a4\u30eb\u540d,URL)\u53d6\u5f97\r\n'\u30d5\u30a1\u30a4\u30eb\u306a\u3057:NoFile, \u30d5\u30a1\u30a4\u30eb\u3042\u308a:\u30d5\u30a1\u30a4\u30eb\u540d;URL, \u30a8\u30e9\u30fc:Err\r\n  Dim ret\r\n  Dim js\r\n  Dim scr\r\n  Dim d\r\n  Dim elm\r\n    \r\n  js = "": ret = "NoFile" '\u521d\u671f\u5316\r\n  On Error Resume Next\r\n  With CreateObject("MSXML2.XMLHTTP")\r\n    .Open "GET", "https:\/\/apis.live.net\/v5.0\/" & id & "\/files\/", False\r\n    .setRequestHeader "Authorization", "Bearer " & code\r\n    .send\r\n    If .Status = 200 Then js = .responseText\r\n  End With\r\n  If Len(js) > 0 Then\r\n    js = Replace(js, vbCr, "")\r\n    js = Replace(js, vbLf, "")\r\n    js = Replace(js, vbCrLf, "")\r\n    js = "(" & js & ")"\r\n    Set d = CreateObject("htmlfile")\r\n    Set elm = d.createElement("span")\r\n    elm.setAttribute "id", "result"\r\n    d.appendChild elm\r\n    scr = "var objects= eval('" & js & "').data;"\r\n    scr = scr & "var j=0;"\r\n    scr = scr & "for(var i in objects){"\r\n    scr = scr & "  if(objects[i].type=='file'){"\r\n    scr = scr & "    if(j==0){"\r\n    scr = scr & "      document.getElementById('result').innerText=objects[i].name+"";""+objects[i].source;"\r\n    scr = scr & "    }else{"\r\n    scr = scr & "      document.getElementById('result').innerText=document.getElementById('result').innerText+""\\n""+objects[i].name+"";""+objects[i].source;"\r\n    scr = scr & "    }"\r\n    scr = scr & "    j++;"\r\n    scr = scr & "  }"\r\n    scr = scr & "}"\r\n    d.parentWindow.execScript scr\r\n    If Len(elm.innerText) > 0 Then ret = elm.innerText\r\n  End If\r\n  If Err.Number <> 0 Then Err.Clear: ret = "Err"\r\n  On Error GoTo 0\r\n  GetFilesInfo = ret\r\nEnd Function\r\n\r\nPrivate Function EncodeURL(ByVal sWord)\r\n  Dim d\r\n  Dim elm\r\n  \r\n  sWord = Replace(sWord, "\\", "\\\\")\r\n  sWord = Replace(sWord, "'", "\\'")\r\n  Set d = CreateObject("htmlfile")\r\n  Set elm = d.createElement("span")\r\n  elm.setAttribute "id", "result"\r\n  d.appendChild elm\r\n  d.parentWindow.execScript "document.getElementById('result').innerText=encodeURIComponent('" & sWord & "');"\r\n  EncodeURL = elm.innerText\r\nEnd Function\r\n\r\nPublic Sub IE_DocumentComplete(ByVal pDisp, url)\r\n  If InStr(url, REDIRECT_URL & "#access_token=") Then ParamGet = url\r\nEnd Sub\r\n\r\nPublic Sub IE_OnQuit()\r\n  FlgIeQuit = 1\r\nEnd Sub<\/pre>\n
\u4e0a\u8a18\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001”FOLDER_NAME<\/span>“\u3067\u6307\u5b9a\u3057\u305fSkyDrive\u30d5\u30a9\u30eb\u30c0\u30fc\u5185\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u306b\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"\u524d\u56de\u306fSkyDrive API\u3092\u5229\u7528\u3057\u3066\u30c9\u30e9\u30c3\u30b0&\u30c9\u30ed\u30c3\u30d7\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092SkyDrive\u4e0a\u306e\u30d5\u30a9\u30eb\u30c0\u30fc\u306b\u30a2\u30c3\u30d7\u3059\u308bVBScript\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u306f\u9006\u306bSkyDrive\u4e0a\u306e\u30d5\u30a9\u30eb\u30c0\u30fc\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed […]","protected":false},"author":1,"featured_media":7132,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[97],"class_list":["post-2503","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vbs","tag-skydrive-api"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-VBScript.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-En","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2503","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2503"}],"version-history":[{"count":3,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2503\/revisions"}],"predecessor-version":[{"id":2506,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2503\/revisions\/2506"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7132"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}