B
Buckle
I have a spreadsheet that has a web query to a subscribed site. Before
run the query, I have to go to Internet Explorer and log into the site
After that I can run the query and extract the data, however now an
then I lose the login. I would like to have a function that logs m
into that site via Excel. I've tried:
=HYPERLINK("http://www.someplace.com/login.aspx?id=username&pw=123456","clic
to login")
This works but a window opens in IE or if there's a window open, thi
will execute in that window. I was wondering if there's a way to hav
this execute in the background without it opening a window. Maybe I'
on the wrong track.
Thanks to anyone who can help
run the query, I have to go to Internet Explorer and log into the site
After that I can run the query and extract the data, however now an
then I lose the login. I would like to have a function that logs m
into that site via Excel. I've tried:
=HYPERLINK("http://www.someplace.com/login.aspx?id=username&pw=123456","clic
to login")
This works but a window opens in IE or if there's a window open, thi
will execute in that window. I was wondering if there's a way to hav
this execute in the background without it opening a window. Maybe I'
on the wrong track.
Thanks to anyone who can help