See
http://www.rondebruin.nl/saveas.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JNW" wrote in message ...
I've got some code that closes a code generated workbook and saves during the
close.

Workbooks(Workbooks.Count).Close _
savechanges:=True, _
Filename:=FName & "Myfile.xls"

FName is the folder location.

When running the code in xl2007 the code generated/closed/saved files can
only be opened in xl2007.

When running the code in xl2003 the files can be opened in both 07 and 03,
but when opening in 2007 there is a warning message first.

Has anyone seen this? and more importantly, does anyone know how to remedy it?

Thanks,
--
JNW