I'm trying to get xl2000 (and hopefully xl2003) to login with a
username and password using vba/a macro.
Very specifically the site I'm trying to get excel to log into
automatically is www.racingpost.co.uk
I have set up a dummy account there with user and password thebotcher
and rehctobeht respectively.
In xl2003 I can manually get excel to login by editing a web query,
bringing up the login page of racing post and logging in within the
Edit Web Query dialog box (New Web Query also works), then exiting
the dialog box with Cancel or just closing it; thereafter all further
web queries to the site work fine for that session. I can't even get
that far in xl2000.
(Just logging into the site in IE does not allow excel to gain access)
I'd like some help, please, so that a less computer literate user can
login (especially with xl2000)