Here is the post:
Message 2 in thread
From: Neil Twomey )
Subject: Web Query Problem
View this article only
Newsgroups: microsoft.public.excel.querydao
Date: 2002-08-28 09:56:25 PST
I have a spreadsheet (using Excel 2000) that does a web
query to a password protected Domino view. The problem is
that I can successfully pull down the view's information
only occasionally. More often than not, the message I get
is that I'm not authorized to access the site (which is
not true).
Here is the .iqy file that I'm using:
WEB
1
http://mywebsite.com/eQA_dev/eqapro.nsf/HSGCASTally?
OpenView&UserName=["User Name","Enter your user name."]
&Password=["Password", "Enter your password."]
I've played around with all the Web Query settings
extensively and there seems to be no rhyme or reason as to
when this will work and when it won't. Yesterday I
thought I had narrowed it down to a caching issue, because
several times I was able to delete IE 5.5's cache and
history and then I cleared my Win2K recent documents list
and I was able to get in. Problem is, this morning the
same things did not seem to work. Can anyone point me in
the right direction here?
Thanks,
Neil-- Regards,Tom Ogilvy"claytorm "
wrote in message
...
I couldn't follow the link. Could you post it again?
Thanks very much,
Bertie.
---
Message posted from http://www.ExcelForum.com/