Hi All
Curious issue has arisen with xl2007 (SP1); I am creating a new workbook
based on a template file (xlt) that was created using xl2003 (SP3). The new
workbook is created and assigned to a workbook object wbTemp.Which I then
wish to save in xl2003 format.

I tried without success both of the following....

wbTemp.SaveAs Filename:="D:\Test.xls", FileFormat:=xlExcel9795

wbTemp.SaveAs "D:\Test.xls", xlExcel9795

When run it I get Run-time error 1004 - Method of 'SaveAs' of object
'_Workbook' failed

What is wrong?

PS if I remove the FileFormat parameter it works but of course the format
reverts to xl2007 with an xls extension!

--

Regards,
Nigel