comparing cells in different workbooks - open a certain sheet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open four Wbooks, copy four columns from each to Master Wbook 16
linking sheets and workbooks 0
Cell values to an array, then array transpose to another workbook 8
Similar Book to Book Code, one works other does not 11
Emailing a sheet from a workbook with VBA 0
Compare two different workbook sheet to show the difference in text 0
Copy from one workbook to another failing 8
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Top