Password needed for Web query

Kestrel

New Member
Joined
Oct 7, 2002
Messages
5
Morning folks,
I have a sheet which uses a web query to retrieve data from a site. You are asked to enter the password when loading the data. I would like to pre-empt this by including password in my code. Any thoughts?
Thanks for the help.
K.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

ChrisUK

Well-known Member
Joined
Sep 3, 2002
Messages
675
Hi.

If the password forms part of the URL it's easy to do, if not then you have a problem on your hands! Take a look at some of the MS investor supplied queries which come with Excel, if you edit the iqy file in something like notepad you will see you can prompt the user for information. There are also some further 'bits' after the URL in the iqy file, I wonder if you can specify here Password = "123" ? worth a try.

Failing this use XMLHTTP, this grabs the page for you, the problem here is you need to unscramble the data from the HTML - not easy but not impossible either.

Hope this helps
 

Kestrel

New Member
Joined
Oct 7, 2002
Messages
5
Thanks for the start, ChrisUK.
I appreciate it.
Later.
This message was edited by Kestrel on 2002-10-09 10:31
 

Forum statistics

Threads
1,144,208
Messages
5,723,032
Members
422,476
Latest member
beck85

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top