External Data Queries and Cookies

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

I have been using excel to query a web page. I am a
subscriber of the page. Recently, the page has started
requiring authenticity through the "cookie" theory. Web
support has said that I have to figure out a way to get
excel to "carry the cookie" (whatever that means).

I would appreciate any hint on where to start. Even
better, if anyone would be willing to solve the problem
for a fee, that would be great.
 
Roger,

You could set the query to pull data off a local file instead then use an
event to refresh the local file from the website.

eg.
Use the querytable BeforeRefresh event to run an external program (such as
wget) which refreshes the local copy from the external website.

Rob
 
Back
Top