ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   problem with SaveAs method of excel in IIS 5 (https://www.excelbanter.com/excel-programming/356475-problem-saveas-method-excel-iis-5-a.html)

Ayoung Chueng

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