W
Walt
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
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