It isn't at all clear what you are asking. If you mean that you want
to run a procedure depending on what day of the week it is, use code
like the following:

Sub Auto_Open()
Select Case Weekday(Now, vbSunday)
Case 1 'sunday
' run procedure 1
Case 2 'monday
' run procedure 2
Case 3 'tuesday
' run procedure 3
'... as so on to 7 = Saturday
End Select
End Sub

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Wed, 31 Dec 2008 09:19:05 -0800 (PST), wrote:

What day of the week it is and open a certian workbook and run a
certain macro. New to this and need some help. Do now somewhat about
vb that works inside of excel.
I would be Thankful for any help..