External Data Queries and Cookies

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.
 
R

Rob van Gelder

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top