Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Web query on password protected page

Hi,

(I've posted this before, but adding a bit more detail this time)

I want to run a web query on a password protected page. I wa
previously pointed to this as a solution that apparantly sometime
works:

WEB
1
http://mywebsite.com/eQA_dev/eqapro.nsf/HSGCASTally?
OpenView&UserName=["User Name","Enter your user name."]
&Password=["Password", "Enter your password."]

Is there anyone with knowledge of VBA who could customize this to m
situation?

The URL I'm trying to access and have the username and password fo
is:
http://tinyurl.com/49yes
When you try to go directly to this page, the URL remains static, bu
the password prompt page appears.

I would be really grateful if anyone can find a solution to this one
It would save literally hours of copy and paste!

Thanks,

Bertie

--
Message posted from http://www.ExcelForum.com

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
password protected page not opening by web query vive2567 Excel Worksheet Functions 0 January 13th 06 03:20 AM
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. Daniel Excel Worksheet Functions 0 June 23rd 05 11:56 PM
bypass password when update linking of password protected file Yan Excel Discussion (Misc queries) 1 February 7th 05 11:29 PM
How can I use web query with a password protected page? claytorm[_3_] Excel Programming 6 August 22nd 04 08:39 PM
Web Query - UserID/Password Protected Textbox tholt2 Excel Programming 0 June 29th 04 04:28 AM


All times are GMT +1. The time now is 05:02 PM.

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"