hi there,

wonder if you could help with the following:

If you could create a macro which can create tabs according to the number of
days of each month, eg 28 tabs for Feb 07, then name it according to the
date, eg 01.02.07, and at the same time create one tab acting as an abstract
which contains hyperlink to each tab.

Sounds really a bit complicated. Your assistance will be much appreciated.

Here is the first part:


Sub demo()
For i = 1 To 31
v = Format(DateValue("3/" & i & "/2007"), "mm.dd.yyyy")
Set sht = Sheets.Add
sht.Name = v
Next
End Sub



--
Gary''s Student
gsnu200710


"May" wrote:

> hi there,
>
> wonder if you could help with the following:
>
> If you could create a macro which can create tabs according to the number of
> days of each month, eg 28 tabs for Feb 07, then name it according to the
> date, eg 01.02.07, and at the same time create one tab acting as an abstract
> which contains hyperlink to each tab.
>
> Sounds really a bit complicated. Your assistance will be much appreciated.