Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate one Book then another Book
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate one Book then another Book
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 befo like this (you don't need to activate) workbooks("Book_cup .xls").sheets("Sheet1").copy _ after:=Thisworkbook.sheets(Thisworkbook.sheets.cou nt) "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy worksheets to new book without linking to original book | Excel Discussion (Misc queries) | |||
'BeforeClose' code problems:book won't close if more than one book is open | Excel Programming | |||
Worksheet Activate event if only one sheet in book | Excel Programming | |||
search all sheets in book to find value and activate sheet with va | Excel Programming | |||
Open book, check for macros, close book | Excel Programming |