Hi, I am accesing a excel file from .NET web application. This excel file is a used as a template with macro written inside.Following program code calls the excel file . ConnExcel = server.CreateObject("ADODB.Connection") ConnExcel.ConnectionString = "Driver={Microsoft Excel Driver (*.xls)};DBQ=" & strExcelReportPath & "; ReadOnly=False;" ConnExcel.Open Everything works fine.But this excel gets corrupted over time and gives error when you try to call it. Error is "[ODBC Excel Driver]General error unable to open the registry key 'Temporary(volatile)jet DSN for process thread Excel. By replacing the corrupted excel with a backup copy,things work fine. Please can anyone help me as to know what makes this excel template corrupted.
