AboutSyed Rizwan Muhammad Rizvi Expertise I can answers questions regarding web based and desktop based programming in VB.Net. Which can include SOAP, XML, Custom Controls, COM Interoperability etc.
Experience Have been working in this specific area for last 2 years previously I was a VB 6 Developer with experties in other languages as well. Total 10 years of programming experience.
Question QUESTION: Website created in VS2005 can access Excel sheets as well as update from gridview. But when this site is published in IIS (or may be later on Webserver) simply goes to wait state - in the status bar message shown is - waiting for http://localhost/website1/excelread.aspx -
Statements used are simly
xlsfile = "E:\accounts\budget.xls"
With objExcel
.Visible = True
.Workbooks.Open(xlsFile)
End With
Kindly suggest any changes I am supposed to make
Regards
Vinod
ANSWER: Assuming that Excel runtime is installed on the server, check to see if IIS has permissions to run the Excel COM.
Regards,
Rizwan
---------- FOLLOW-UP ----------
QUESTION: Dear Rizwan,
Thanks for your guidance as under -
Assuming that Excel runtime is installed on the server, check to see if IIS has permissions to run the Excel COM.
But -Please pardon my ignorance. How to find it IIS has such permisions? And what is the procedure to affect these permissions
Thanks again
Vinod
Answer before going into how to fix the problem a very simple way to test it is that in the same Virtual Directory you create another very simple page without any error handling. write some Excel object creation code in it, run it and test it, if it generates any error it would be displayed on screen anyway. if it doesnt and work then it means you have made some other mistake in your code which neads to be solved.
