Hi All,

I have a problem about using PIA(Primary Interop Assembly) in vb.net. I declare a variable handling the Microsoft.Office.Interop.Excel.Application like this dim sample as Microsoft.Office.Interop.Excel.Application and instantiate like this sample =New Microsoft.Office.Interop.Excel.Application. when I run the program I got this error "ACCESS DENIED", i trace the program and the origin of the error is this code sample =New Microsoft.Office.Interop.Excel.Application. I configured the Microsoft Excel Application in Conponent Services and given permission to ASPNET account and my account also which i used in my windows log-in but nothng happens. I configured also the WebConfig file by setting the identity impersonate to true and set user and password but nothing happens. I have also tried to give access the ASPNET and my windows log-in account to the folders i have work and to the file i have access but nothing happens. I am stuck with this problem , Please help who have any ideas about this.