I think the format you want is xlWorkbookNormal.

And xlExcel9795 workbook includes both xl95 format and xl97 format. It's
double the normal size.

On 08 Apr 2005 11:12:00 GMT, CoRrRan Have a look at this code:

Code:

ActiveWorkbook.SaveAs FileName:= _
    "C:\Temp\Book2.xls", FileFormat:=xlExcel9795

I couldn't find an specific option for saving the file to the current
platform version (your case Excel 2000), but I think that xlExcel9795
should work for your purposes. (As my version (Excel 2003) shows that this
FileFormat will provide a format readable to Excel 97 to 2003.)

HTH,
CoRrRan