ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel error using .NET web application (https://www.excelbanter.com/excel-programming/361130-excel-error-using-net-web-application.html)

sheetjo

excel error using .NET web application
 
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.



All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com