Automatically Insert Sheet
 

Is there a way to have excel automatically add a worksheet
to an excel file upon opening? All files i will be
opening will have only one worksheet. Any direction anyone
could give me would be terrific. thanks, peter

Automatically Insert Sheet
 

Hi Peter

Try this event in the Thisworkbook module

Private Sub Workbook_Open()
Worksheets.Add.Name = Format(Now, "dd-mm-yy h-mm-ss")
End Sub

It will give the sheet a name(Date/Time)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Peter" wrote in message ...
Is there a way to have excel automatically add a worksheet
to an excel file upon opening? All files i will be
opening will have only one worksheet. Any direction anyone
could give me would be terrific. thanks, peter

Automatically Insert Sheet
 

Ron, your advice worked perfectly. thankyou and have a
great weekend. peter



-----Original Message-----
Hi Peter

Try this event in the Thisworkbook module

Private Sub Workbook_Open()
Worksheets.Add.Name = Format(Now, "dd-mm-yy h-mm-ss")
End Sub

It will give the sheet a name(Date/Time)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Peter" wrote in
message ...
Is there a way to have excel automatically add a
worksheet
to an excel file upon opening? All files i will be
opening will have only one worksheet. Any direction
anyone
could give me would be terrific. thanks, peter


.