Sam,

If you are sure that the web page is very static in its format, I would use
the "SendKeys" function in a macro, but you will face some difficulties if
you want to properly interact with Internet explorer as everything will be
hard coded, for example the number of tabs you need to perform to reach the
right link.

Personally, I am using http://www.autoitscript.com for such automation. The
language is close to VBA, so it is easy to learn and you can really do great
things.

Stephane