Hi All,
I have 2 customers out of 1000's who for some reason Excel is failing to save files.
I did run a test on one of the sites with this code:
Local oExcel, oWorkbook, oWorksheet
oExcel = CreateObject("Excel.Application")
oWorkbook = oExcel.Workbooks.Add()
oWorksheet = oWorkbook.Worksheets(1)
oExcel.DisplayAlerts = .F.
oExcel.Cells(1, 1).Value = "AAA"
oExcel.Cells(1, 2).Value = "BBB"
oExcel.Cells(1, 3).Value = "CCC"
oExcel.Cells(1, 4).Value = "DDD"
oWorkbook.SaveAs("C:\Test.xls") &&- errors here
oExcel.Quit()
Return
Any ideas please?
Thank you
Mathias Banda
Time is longer than a rope.