![]() |
problem with SaveAs method of excel in IIS 5
I want to transform excel to html.
I create a object with Set excelObj = Server.CreateObject("Excel.Application") and use the object as following excelObj.DisplayAlerts = False excelObj.Interactive = False excelObj.ScreenUpdating = False excelObj.Workbooks.Open TempPath & repFileName & ".xls" excelObj.Workbooks(1).Activate excelObj.Workbooks(1).RefreshAll excelObj.Workbooks(1).SaveAs TempPath & repFileName & ".htm",44 An error is issued at the last line: Microsoft Excel error '800a03ec' Method SaveAs of class Workbook is invalid. what's wrong? permissions? |
All times are GMT +1. The time now is 02:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com