comparing cells in different workbooks - open a certain sheet
 

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