Web Data Query using Cookies

[99bobster99]

Hi,

I am trying to access data (download an xls file) from a secure website, that I subscribe to. When I try to download the file using IE, directly, it works fine. When I try to download this file using Excel, via a Web Query, I receive an older, outdated file. I noticed that when I do this using IE a Cookie is exchanged with the server prior to the download. Is there a way to replicate this same cookie exchange using VBA ??

Many thanks.

 

[99bobster99]

I've found that "HttpWebRequest", "CookieCotnainer" and "InternetGetCookie" might do the trick. I'm having troubles getting any of the code on the web to extract data from a website requiring cookies. Does anyone have experience with this ??