>That works for me in 2003 and 2007 (can't test it on 2010):
>
>oExcel.ActiveWorkbook.SaveAs(FORCEEXT(lcExportfile,[XLS]), 39)
>
>Great!
>
>This worked for me too in 2010!!!
>
>I don't know how (what's 39???) but it's a goal.
>
>Then I'll out what means 39 in constants.
>
>Thank you very much, Borislav!
>
> Hector
39 is file format xlExcel5 :-)
Check WorkBook.SaveAs() in VBA Help for more info.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.