VBA to start a new sheet everyday?

[loplop]

Is there a way to make VBA code start on a new sheet everyday? Or even at a certian time?
Right now I have one large running sheet that is keeping track of 3 machines everyday.
Please let me know if this can be done.
PS - I have taught myself anything I know about VBA so please be patient.

[Marc L]

No need VBA, just create a template …

[loplop]

Again..new at this...please explain

[mehmetcik]

If you shut down the PC at night then a simple Auto_Open Macro. Otherwise an OnTime macro. So how do you manage your PC.

I am unfamiliar with templates but I will know more in a few minutes.

[Marc L]

Create the workbook as expected then use the 'Save as' Excel command and choose the template file format as explained in Excel help …

[loplop]

If you shut down the PC at night then a simple Auto_Open Macro. Otherwise an OnTime macro. So how do you manage your PC.

I am unfamiliar with templates but I will know more in a few minutes.

The PC stays running at all times...except maybe on the weekends.
But is i do a time macro....how would the info be saved to the new sheet?
Here is the code that i have for one machine

Please Login or Register  to view this content.

[mehmetcik]

Something like:

You will struggle to close your workbook with OnTime running so run CancelOnTime first.

In your situation you would probable be wise to move the CancelOnTime to the Workbook close event.

That event is found in the ThisWorkbook Macro Module in the Visual Basic Project Explorer.

Let me know if this is double dutch to you and I will send you some Screen Shots tomorrow.

Please Login or Register  to view this content.

[loplop]

Yes....this is double dutch! And the not the rope jumping!!
Please send me some screen shots.