Hi to all!!!

I have 3 woorkbook opened.
Book1 , Book_cup , Book_sec.
I need to activate Book_cup from Book1.In to Book1 I need to paste all thata
from sheet1 from Book_cup and then insert vlookup ( look for data from
Book_sec), formula in cell A4.
Then I need activate Book_sec.In Book_sec I need to formated column B in to
number on sheet2 i sheet3.

Any help will be appreciated


Sorry for bad englich!!!
regards
lopina

to activate another workbook use

workbooks("Book_cup .xls").activate

to copy a worksheet from one workbook to another you need to use .copy with
either after: or before: like this (you don't need to activate)

workbooks("Book_cup .xls").sheets("Sheet1").copy _
after:=Thisworkbook.sheets(Thisworkbook.sheets.count)




"lopina" wrote:

> Hi to all!!!
>
> I have 3 woorkbook opened.
> Book1 , Book_cup , Book_sec.
> I need to activate Book_cup from Book1.In to Book1 I need to paste all thata
> from sheet1 from Book_cup and then insert vlookup ( look for data from
> Book_sec), formula in cell A4.
> Then I need activate Book_sec.In Book_sec I need to formated column B in to
> number on sheet2 i sheet3.
>
> Any help will be appreciated
>
>
> Sorry for bad englich!!!
> regards
> lopina
>
>
>