View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Walt[_2_] Walt[_2_] is offline
external usenet poster
 
Posts: 4
Default 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