vba - Import A CSV File into Excel (Requires Login/Pass) -

-

i've looked @ dozens of similar topics here without finding i'm looking for. if doing manually, navigate url, given parameters:

https://the.website.com/mobile/rest/reportservice/exportreport?name=shared%2fmv+report.ppr&format=csv&showtotals=false&valuedate=today

when go there, requests username , password in pop-up box, enter, , downloads csv.

this python code works perfectly:

import requests requests.auth import httpbasicauth  username = "i_cant_tell_you_guys" password = "definitely_cant_share_this"  auth = httpbasicauth(username, password)  url = "https://the.website.com/mobile/rest/reportservice/exportreport?name=shared%2fmv+report.ppr&format=csv&showtotals=false&valuedate=today"  resp = requests.get(url.format(username, password), auth=auth, verify=false)  print resp.content

but can't seem replicate in vba. possible? if not, have excel , python work somehow?

thanks!

edit: several people suggested approach: vba winhttp download file password proteced https website since url i'm pulling isn't actual file url, won't work.

edit: got working. website had certificate mismatch, had tell winhttp ignore ssl errors. here's new code:

sub savefilefromurl()      const option_sslerrorignoreflags = 4     const sslerrorflag_ignore_all = 13056     const httprequest_setcredentials_for_server = 0      dim filenum long     dim filedata() byte     dim whttp object      mainurl = "https://website.com"     fileurl = "https://website.com/myfile.csv"     filepath = "c:\myfile.csv"      myuser = "login"     mypass = "pass"      set whttp = createobject("winhttp.winhttprequest.5.1")       whttp.open "post", mainurl, false     whttp.setcredentials myuser, mypass, httprequest_setcredentials_for_server     whttp.setrequestheader "content-type", "application/x-www-form-urlencoded"     whttp.option(option_sslerrorignoreflags) = sslerrorflag_ignore_all      whttp.send      whttp.open "get", fileurl, false     whttp.send      filedata = whttp.responsebody     set whttp = nothing      filenum = freefile      open filepath binary access write #filenum         put #filenum, 1, filedata     close #filenum      msgbox "file has been saved!", vbinformation, "success"  end sub

now i'm getting "run-time error '75': path/file access error"


Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more