the specified session is not available error in excel in win 7

Dear all,

I am working with excel sheet in win7 environment. I am attaching my file. while i am clicking my excel application " the specified session is not available" error is comming.

any one help me to rectify this error.

Thanks in advance,
Santhi.DTLNAV-POI Macro Revised 10072010.xls

Hi,

That error is comming when I am clicking the command buttons.

Thanks,
Santhi.

Hi pandey,

I saw your mail in Excel help sight. Below are my queries. Could you please help me to sloving this issues.

My work environment is WIN 7, Excel 2010

1. Set sess = System.Sessions.Item(sessname0$) : in this line "specified session is not available" error is comming.

Public Sub UserForm_Activate()
'If Weekday(Date, vbSunday) = 1 Then
'EntryDateBeg = Date - 2
'ElseIf Weekday(Date, vbSunday) = 2 Then
'EntryDateBeg = Date - 3
'Else
'EntryDateBeg = Date - 1
'End If
'Me.Calendar1.Value = EntryDateBeg
'Me.Calendar2.Value = Sheets("Home Sheet").Range("AB2").Value
'End Sub

for calendar control we are using above code. but in this line "me.calendar1.value = entrydateBeg " error is comming. the error is "Can't find project or library"

How to rectify this and how to get calendar control in my form.

Thanks,
Santhi.