SaveAs error

Results 1 to 2 of 2

Thread: SaveAs error

  1. #1
    Join Date
    Dec 1969

    Default SaveAs error

    I created the Excel application and wants to save it as Web page<BR><BR>My codes are as follow:<BR><BR>Set excelObj=CreateObject("Excel.Application")<BR>Set xlBook = excelObj.Workbooks.Open(excelPath,0,ReadOnly)<BR>x lBook.SaveAs "D:Trial.htm", xlHtml<BR><BR>When i execute the code, i get this error:<BR><BR>Microsoft Excel error &#039 800a03ec&#039 <BR>SaveAs method of Workbook class failed <BR>/kpi/checkFile.asp, line 139 (--&#062; which is refering to SaveAs statement)<BR><BR>Is my syntax wrong??<BR>how should i code it???<BR>thanx<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SaveAs error

    Where are you getting the value of <BR>&nbsp;&nbsp;&nbsp;&nbsp;xlHtml<BR>from? It isn&#039t built into anything I could find. (It&#039s not<BR>even included in the type library constants of the Excel object,<BR>according to my OLE viewer.)<BR><BR>You may need to code it explicitly as the proper number, because<BR>it will be zero if it isn&#039t defined anyplace.<BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts