I work for a large chain coporation. My schedule is posted on their
secure web site which I have a user name and a password for.
I want to create a URL string that can be sent (using VBA inside of
Outlook) which contain my username and passsword and allow me access
to my schedule information.

I tried:
IE.Navigate2
"https://mydish.olivegarden.com/company/TOG/home.asp?user=[myusername]&password=[mypassword]"
where [myusername] and [mypassword] were replaced by the actual
strings I use to login through the web site.

That doesn't work. I guessed at the variable names "user" and
"password". I looked through the login pages source text for help
here, but didn't find any.
I also noticed the login URL has the text "...netegritysplash.asp..."
in it? here is the full
URL:"https://mydish.olivegarden.com/siteminder/netegritysplash.asp?TYPE=33554433&REALMOID=06-ff731848-1ef6-4793-bc06-53077be31783&GUID=&SMAUTHREASON=0&TARGET=$SM$https%3a%2f%2fmydish%2eolivegarden%2ecom%2flogin%2easp&SMIDENTITY=NO"

Can anyone tell me how piece together a URL so I can include my
username and password thus directly downloading the schedule
information into a VBA program without physically going to the web
site using Explorer or Firefox?

Thanks in advance!

Re: Downloading web page from secure ASP web site. by Anthony

Anthony
Sat Jul 05 12:31:43 CDT 2008

"Dave the Wave" <dweeber@hotbot.com> wrote in message
news:h69v64dla3q0s24hubb234smk56krljkfg@4ax.com...
> I work for a large chain coporation. My schedule is posted on their
> secure web site which I have a user name and a password for.
> I want to create a URL string that can be sent (using VBA inside of
> Outlook) which contain my username and passsword and allow me access
> to my schedule information.
>
> I tried:
> IE.Navigate2
>
"https://mydish.olivegarden.com/company/TOG/home.asp?user=[myusername]&passw
ord=[mypassword]"
> where [myusername] and [mypassword] were replaced by the actual
> strings I use to login through the web site.
>
> That doesn't work. I guessed at the variable names "user" and
> "password". I looked through the login pages source text for help
> here, but didn't find any.
> I also noticed the login URL has the text "...netegritysplash.asp..."
> in it? here is the full
>
URL:"https://mydish.olivegarden.com/siteminder/netegritysplash.asp?TYPE=3355
4433&REALMOID=06-ff731848-1ef6-4793-bc06-53077be31783&GUID=&SMAUTHREASON=0&T
ARGET=$SM$https%3a%2f%2fmydish%2eolivegarden%2ecom%2flogin%2easp&SMIDENTITY=
NO"
>
> Can anyone tell me how piece together a URL so I can include my
> username and password thus directly downloading the schedule
> information into a VBA program without physically going to the web
> site using Explorer or Firefox?
>


Your username and password will not be encoded into the URL in such an open
an insecure manner. There are all sorts of different schemes for handling
authentication but typically over https it will be handled by a HTML form.

What you are trying to do may be possible but you're going to have to jump
through several hoops backward to do it and may well be viewed as a hack.
Is this requirement sanctioned by Olive Garden? If not they may not be too
please by the attempt.



--
Anthony Jones - MVP ASP/ASP.NET