I am using following code to validate excel,actually this code is working
VB but in ASP its giving Error what could be the problem
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

bjXL.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