|
|
Web query from password protected page?
Version: 2004
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
Hi, <br><br>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". <br><br>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.
|
|
0
|
|
|
|
Reply
|
 pdj316
|
2/27/2010 1:42:24 PM |
|
For the record, the site I'm trying to query is: <br><br><a href="http://www.rotowire.com/draft/mlb/da_player.asp?id=10762">http://www.rotowire.com/draft/mlb/da_player.asp?id=10762</a> <br><br>> Hi, <br>
> <br>
> 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". <br>
> <br>
> 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.
|
|
|
0
|
|
|
|
Reply
|
pdj316
|
2/27/2010 2:58:56 PM
|
|
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
On 2/27/10 8:42 AM, in article 59bb38ae.-1@webcrossing.JaKIaxP2ac0,
"pdj316@officeformac.com" <pdj316@officeformac.com> wrote:
> 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.
|
|
|
0
|
|
|
|
Reply
|
CyberTaz
|
2/27/2010 3:55:35 PM
|
|
|
2 Replies
882 Views
(page loaded in 0.047 seconds)
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
1146 articles. 
14 followers. 