A
Axcell
I have an excel template that I use for a weekly time sheet. Each week
input the data into the cells and print the sheets for each job an
then fax to the main office. Kind of getting to be a tedious process.
What I would like to do is have all the time sheets added to on
workbook named by the date, and then email the workbook to the offic
to save quite a few steps.
So far, using VBA, I am able to rename the worksheet (template) whe
completed with the job name, create the workbook "2-28-04.xls", an
then copy the activesheet to the workbook and close the workbook.
The problem I cannot figure out is how to write the routine for th
next timesheet. I realize I need to see if the workbook exists and i
so how do I open the book and add the additional worksheet, and so o
for about 10 sheets?
I appreciate any help, thanks!
Ale
input the data into the cells and print the sheets for each job an
then fax to the main office. Kind of getting to be a tedious process.
What I would like to do is have all the time sheets added to on
workbook named by the date, and then email the workbook to the offic
to save quite a few steps.
So far, using VBA, I am able to rename the worksheet (template) whe
completed with the job name, create the workbook "2-28-04.xls", an
then copy the activesheet to the workbook and close the workbook.
The problem I cannot figure out is how to write the routine for th
next timesheet. I realize I need to see if the workbook exists and i
so how do I open the book and add the additional worksheet, and so o
for about 10 sheets?
I appreciate any help, thanks!
Ale