| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem using SaveAs method | Excel Discussion (Misc queries) | |||
| Excel SaveAs() method | Excel Programming | |||
| A little help with SaveAs Method please | Excel Programming | |||
| Error Excel: 1004 SaveAs method of Workbook class failed | Excel Programming | |||
Linear Mode
