k_santu
02-27-03, 05:02
| I am using following code to validate excel Dim objXL ,objWkBook Set objXL = CreateObject("EXCEL.application") ' objXL.Application.Visible = True Set objWkBook = objXL.Workbooks.Add objXL.Range("A2").Validation.Add Type:=xlValidateDecimal, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="0.1", Formula2:="5" objXL.Range("A3").Validation.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlValidAlertStop, Formula1:="1,1,1,1" objXL.ActiveWorkbook.SaveAs "C:\Test1.xls" objXL.Quit Set objXL = Nothing So I am getting error like COM Error Number :-2146827286 (0x800A03EA) Error Source :objXL.Range("A2").Validation.Add Type:=xlValidateDecimal, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="0.1", Formula2:="5" File Name :/excel.asp Line Number :26 Brief Description: Syntax error and also how to validate Excel using this excel object Set objSpreadsheet= Server.CreateObject("OWC.Spreadsheet") Thanx Kaithi |