Use Sendkeys to send Ctrl-A Ctrl-C to Internet explorer (after you activate
the hyperlink)


Something like

Activate the hyperlink
SendKeys "^(AC)", true

Application.activate ' to bring you back to excel

Name of macro called by ctrl-z

I think this will need some experimenting and tidying but it should be enough
to get you started.