>Hi friends:
>
>A client of mine is worried because many of his clients asks for mail about his prices. I asked me if it is possible to send them a mail with the information.
>
>I said "I'm going to think about it"
>
>I sat down here and I programmed a "simple" program that creates a MS Excel file to attach with a mail. Everything was right but in other client I had the problem the CONSTANTS of Excel 2010 are not the same with 2007 (I love Microsoft) so I decided "saveas(nfile)" instead of "saveas(nfile,nconstant)" (I'd like a 2003 Excel file XLS)
>
>Well. I installed the program, I ran it. Guess what? When I try to attach the XLS file it doesn't exists.
>
>I search it and I find it where I expect but it is a.. ¡Binary 2007 Excel file!!!
>
>How is it possible? My client hasn't lights enough to select "binary excel book" as default.
>
>I looked for the Excel version of my client and it is 2003! not 2007 And obviously saves files as default (XLS)
>
>Does anyone know a way for "saveas" which can be predictable in 2003, 2007 and 2010 Excel version?
>
>I must say a year ago or so I bought a e-book because an advise here about "Office automation" but didn't help for this. Also in many questions says the damm explanation: "If you want to know more about it see the MS Offfice help"...
>
>Thank you
>
> Hector


That works for me in 2003 and 2007 (can't test it on 2010):

oExcel.ActiveWorkbook.SaveAs(FORCEEXT(lcExportfile,[XLS]), 39)