I am using the following code to get a file:
It works really fast but the problem is that I have to log in to that website so that I can download the file, is there a way to do so?
Dim FileData() As Byte Set WHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1") WHTTP.Open "GET", myurl, False WHTTP.send FileData = WHTTP.responseBody Set WHTTP = Nothing FileNum = FreeFile Open "D:\bla.txt" For Binary Access Write As #FileNum Put #FileNum, 1, FileData Close #FileNum
Last edited by arlu1201; 08-01-2012 at 10:00 AM.
Possibly, but it depends on the website. Without seeing it, there's no real way of advising you
yahoo.com is the website I need to be logged into. Thanks
Excelfrogs,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I'd need more than that I'm afraid.
The winHTTPObject does support the passing of credentials, I suggest you read up on it and see how far you get, but don't hold your breath
---------- Post added at 03:34 PM ---------- Previous post was at 03:31 PM ----------
Oh, and please don't crosspost
Any other method you would recommend perhaps?
I don't think you're going to find one, not easily at any rate. It will be a lot of trial and error and you'd need a good understanding of web technologies
dang it!!!
I suppose you could work around by automating ie, but honestly whilever you're logged into the site, doing it the way you're doing it would be just as fast
yes but the way i'm doing it it's impossible because i need to be logged in, so i will have to fine another way that downloads it in the background
Whichever way you're doing it, you're going to have to log in at some point
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks