Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default External Data Queries and Cookies

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Inport External Data - new queries Lozza65 Excel Worksheet Functions 1 November 26th 07 10:55 AM
Excel 2002 External Data Queries and UNC !HELP! KayC Excel Discussion (Misc queries) 0 April 23rd 07 10:33 AM
External Data Queries - Data Range Properties v Spreadsheet Format HLS Excel Discussion (Misc queries) 0 April 5th 06 11:09 AM
Excel 2003 This Workbook contains queries to external data Puzzled of Springburn Excel Discussion (Misc queries) 0 February 8th 05 03:21 PM
External data queries within applcation collection Andy S Excel Programming 2 November 24th 03 08:44 PM


All times are GMT +1. The time now is 08:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"