I currently have numerous workbooks (one for each employee) containing thier
timesheets for the current year (file name: "[NAME] TimeSheet's 2008.xls").
the tabs in these workbooks are simply named by the week ending date (every
saterday).

I would like to have a special workbook that's only perpose is to batch
print all or certain timesheets.
In this wkb, i would have a cell in which i type the week ending date that i
want to print. I am thinking it could search all files in a folder for that
tab name and print them OR furthurmore, I would also like to have a list of
employees names that I could check off, or something, if i want the timesheet
for that person printed.

would any of this be possible?
Thanks

Hi

Here's the skeleton of the code: http://www.ozgrid.com/VBA/loop-through.htm


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"KUMPFfrog" wrote:

I currently have numerous workbooks (one for each employee) containing thier
timesheets for the current year (file name: "[NAME] TimeSheet's 2008.xls").
the tabs in these workbooks are simply named by the week ending date (every
saterday).

I would like to have a special workbook that's only perpose is to batch
print all or certain timesheets.
In this wkb, i would have a cell in which i type the week ending date that i
want to print. I am thinking it could search all files in a folder for that
tab name and print them OR furthurmore, I would also like to have a list of
employees names that I could check off, or something, if i want the timesheet
for that person printed.

would any of this be possible?
Thanks

Thanks for the reply, but I should have mentioned that I am not a macro user,
so I need a macro built for dummies.

"Wigi" wrote:

Hi

Here's the skeleton of the code: http://www.ozgrid.com/VBA/loop-through.htm


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"KUMPFfrog" wrote:

I currently have numerous workbooks (one for each employee) containing thier
timesheets for the current year (file name: "[NAME] TimeSheet's 2008.xls").
the tabs in these workbooks are simply named by the week ending date (every
saterday).

I would like to have a special workbook that's only perpose is to batch
print all or certain timesheets.
In this wkb, i would have a cell in which i type the week ending date that i
want to print. I am thinking it could search all files in a folder for that
tab name and print them OR furthurmore, I would also like to have a list of
employees names that I could check off, or something, if i want the timesheet
for that person printed.

would any of this be possible?
Thanks