opening macro enabled worksheet on server from dotnet application

i am using dot net code to open excel by populating it with data
this functionality works fine on working system with the below macros/vba
but not getting opened from server
i have used datavalidation from vba code to dynamically create & populated list
i have used the function from below link to get the index value of selected data from the list
before using the above function i was able to open the excel sheet from my application on the server but after using this macro /vba it doesnot get opened

http://stackoverflow.com/questions/8...-dropdown-list

Is there any things to be checked on server?

server has Windows 2008 R2 (64-bit)
and my local working system has windows 7 64 bit