View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
 
Posts: 233
Default How to supply your own web query

mark,

there was an Excel 97 SDK, that has some info in webqueries. After that
AFAIK MS when silent on this function. I would not depend on this
function, it his flakey and tricky to use. A webquery is in fact an
HTML table.Webquery parameters are in Fact HTML POST or Get parameters.
Try some testing and see if it works for you.
Are you shure you want to go from an excel file to a web page and back
to an excel file?

If you are just providing internally maybe think of a database. I would
suggest linking to the excel sheet using Get external Data. If it is
for the internet, just upload your file as a csv file for download is
also possible.

DM Unseen