Copy/paste from file opened by macro

Hi,

Yes, just set up two workbook variables for the current book and the one you want to open, say

Please Login or Register  to view this content.

Then after you've opened up the first workbook, use the

Please Login or Register  to view this content.

Then repeat for your second workbook adjusting ranges to suit

HTH

Thanks, but it does not help

I will be more specific

Opening macro

Sub CBR123()
Workbooks.Open "http://cbr.ru/credit/101.asp?regnum=2306&when=0&dt=20080901"
End Sub

Then I need to copy worksheet from opened workbook. Is it possible?

Or is it possible to open that link in entire workbook?

Thanks, man

Thats really what I want (at least now)