View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default External Data Queries and Cookies

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


"Roger" wrote in message
...
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.