create tabs and add hyperlink to each tab
 

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.

create tabs and add hyperlink to each tab
 

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.