opening macro enabled worksheet on 64bit 2008 OS server from dotnet application

i have a dotnet application which exports data to excel & opens it

it works fine on my local system having 64 bit wndows 7 OS

but the same , the excel sheet doesnot get opened on ・Windows 2008 Server x64

i tried solution from net

the below folder already exists still the excel sheet doesnot get opened

C:\Windows\SysWOW64\config\systemprofile\Desktop

A plain excel sheet without macros get s opened on server but with macros it doesnot get opened


===========================================


Log Name: OSession
Source: Microsoft Office 12 Sessions
Date: 12/12/2013 10:31:14 AM
Event ID: 7003
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVER.MYCOMPANY.local
Description:
ID: 1, Application Name: Microsoft Office Excel, Application Version: 12.0.4518.1014, Microsoft Office Version: 12.0.4518.1014. This session was terminated unexpectedly.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft Office 12 Sessions" />
<EventID Qualifiers="0">7003</EventID>
<Level>3</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-12-12T05:01:14.000000000Z" />
<EventRecordID>260</EventRecordID>
<Channel>OSession</Channel>
<Computer>EXCHANGE-SERVER.MYCOMPANY.local</Computer>
<Security />
</System>
<EventData>
<Data>1</Data>
<Data>Microsoft Office Excel</Data>
<Data>12.0.4518.1014</Data>
<Data>12.0.4518.1014</Data>
</EventData>
</Event>

yes on my local system its working without any issue

on server macro is enabled
i have copied the same excel sheet from my system to the server & the excel get opened from my application not manually
the code that creates issue is below


rList = "=Sheet2!$Y$2:$Y$10"
With Sheet1.Range("C9:C" & count)
With .Validation
.Delete
.Add xlValidateList, xlValidAlertStop, xlBetween, rList
.IgnoreBlank = True
.InCellDropdown = True

End With
End With
End If

if i cooment the above code the excel opens from the server
the error i get in event viewer on server is a sbelow