It looks like you're new here. If you want to get involved, click one of these buttons!
XlApp.UserControl(TRUE); XlWrkBk.Close(TRUE,FIleName); XlApp.Quit; CLEAR(XlApp);this code will save prepared excel as default XML format.
XlApp.UserControl(TRUE); XlWrkBk.SaveAs(FIleName,'43'); /// save as excel 97 XlWrkBk.Close(FALSE); XlApp.Quit; CLEAR(XlApp);but it did not work. number 43 I took from this document: http://msdn.microsoft.com/en-us/library/office/bb241279(v=office.12).aspx and I tried it as number too.