Querytable to current browser session

[olle3770]

Hello there!

I have used a very simple script for reatrieving data from a table:

Please Login or Register  to view this content.

The script worked alright before but since the owner of the webpage which the querytable refers to made some changes it is not working anymore. The problem is that you need to be logged in to reach the URL. I think the problem is that the querytable opens a new session(?) of my browser and therefore is not aware of that I am logged in. Is there a way to make the querytable refer to the current browser session?

Or is there some kind of workaround? Appreciate all help!

//Olle

[Chippy]

Yes, the problem is that the query table is entirely separate from your web browser (Internet Explorer to be specific because web queries seem to use IE as the underlying browser for retrieving data) and any IE login session. AFAIK there is no way to make the QueryTable refer to the IE session.

Instead of a web query you'll need to use IE automation to log in to the web site and HTML parsing/manipulation to retrieve the data.

[olle3770]

Thanks for the fast response!

I was afraid of that, the strange thing is that it worked before! I have also noticed that it is important to use IE when working with querytables.

Do you have any good links for IE automationm logging in, and retrieving data?

[Chippy]

Sorry for the delay, but I tried posting 4 URLs on IE automation 2 days ago, but since then the forum has been unavailable to me. (I'm using a proxy server to post this.)

Here's 1 link which hopefully won't cause the same problem:

http://www.tushar-mehta.com/publish_...ices/index.htm

Also search this forum for "InternetExplorer" for many examples.

[olle3770]

Thanks for your help!

I have managed to do the IE-automation on my own. The only problem now is that my boss is a mac-user and does no have IE...

But I do not think it is possible to convert the script to use Safari instead, at least not in the same simple manner?