Excel & VB pasting web page

[toonie]

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

 

[Tom Ogilvy]

workbooks.open "http:\\www.mysite.com\mypage.htm"
' you code here

 

[toonie]

Thanks Tom.

This opens a new workbook, and even then although the page is displayed
it is pretty messed up. What I thought I needed was some sort of PRTSCN
to copy window and then to paste bmp picture of screen into my work
book.

Toonie