>Hi,
>I want to create a worksheet with a filename assigned before open it, I use following code,
>but not success to SaveAs the file and open it.
>
>
>cxlsfile="ABC.xls"
>oExcel = CREATEOBJECT([Excel.Application])
>oWorkbook = oExcel.Workbooks.Add()
>oWorkbook = oExcel.Workbooks.SaveAs(cxlsfile, xlNormal)
>oWorkbook = oExcel.Workbooks.open(cxlsfile)
>
>
>Please advise what is wrong.
>
>Thanks.
>
>Derek
What happens if you don't provide extension for the file?
If it's not broken, fix it until it is.
My Blog