Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Web query from password protected page?
120 views
Skip to first unread message
pdj...@officeformac.com
Feb 27, 2010, 8:42:24 AM2/27/10
to
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.
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.
pdj...@officeformac.com
Feb 27, 2010, 9:58:56 AM2/27/10
to
For the record, the site I'm trying to query is:
http://www.rotowire.com/draft/mlb/da_player.asp?id=10762
http://www.rotowire.com/draft/mlb/da_player.asp?id=10762
CyberTaz
Feb 27, 2010, 10:55:35 AM2/27/10
to
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.
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
On 2/27/10 8:42 AM, in article 59bb3...@webcrossing.JaKIaxP2ac0,
0 new messages