Web query from password protected page?

[pdj316]

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi,

I'm trying to create a web query from a web page that requires a username and password. I have tried logging into the site in Safari (as well as Chrome and Firefox) before running the query, but when I do run it, the only data that's imported into excel is "Username" and "Password".

In the MS version of Excel it's pretty easy to enter the login information into the query (either directly or using VBA), but I can't figure out how to do so in Excel for Mac. Does anyone know if this is possible.

 

[pdj316]

For the record, the site I'm trying to query is:

http://www.rotowire.com/draft/mlb/da_player.asp?id=10762

 

[CyberTaz]

I honestly don't know the answer, but one thought that comes to mind from a
different perspective... Have you added the User Name & Password to your OS
X Keychain or had your browser "remember" it? If it's stored there perhaps
it will be accessed automatically or at least provide a prompt to allow.

Regards |:>)
Bob Jones
[MVP] Office:Mac