workbooks.open "http:\\www.mysite.com\mypage.htm"
' you code here
--
Regards,
Tom Ogilvy


"toonie" wrote in message
oups.com...
Hi, I have posed this question on another VB group and although had
some response, was directed here, hope someone can help.

What I'd like to do is this:-

Whilst my macro/vb script runs (approx 3mins) I want to copy a web page
and paste it into excel worksheet and then allow rest of the code to
continue, while web page displayed.

all of my attempts fail because I cannot capture the screen.

Do you know how I can make this work?

Toonie