N
Nigel
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!
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!