You can try SWExplorerAutomation SWEA (http://webiussoft.com) to
extract data from the password protected Web sites.


ismet wrote:
hi,

i have some problems with excel's web query functions. It works perfectly
fine when i try to import text or any data off a public web site, but as soon
as i try looging in somewhere or going through any login "gate" or check i
get a messege box:
"This Web Query returned no data. ..."
or i get the text off the login site.

Try it yourself at
"http://gmvis.gm.com/gmvis/main/Summary" and enter "00000000000000000"
(seventeen zeros) and try extracting any table content.

I'm thinkin that there is some type of VBA code that might be able to take
care of that. I'm pretty new at VBA so any help is appreciated alot, thanks.