Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi
1. i have to compare cells in different (open) workbooks. i have no idea how to do that. all tries failed :( 2. how can i tell an openroutine looking like Set myWkbk = Workbooks.Open(Filename:=myFileName) which sheet(!) it should open. General Information: The macro gathers the working hours from an individual workbook and copies them into a summary. Each month is one sheet. I want to be sure that i copy the right month (workbook opens on the last saved sheet...). TIA Walt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing Two workbooks | Excel Worksheet Functions | |||
Comparing Two Workbooks | Excel Discussion (Misc queries) | |||
Finding, searching, and comparing cells to another sheet | Excel Worksheet Functions | |||
Comparing Workbooks | Excel Discussion (Misc queries) | |||
comparing workbooks | Excel Discussion (Misc queries) |