save as .xls (97-03 format) with code
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 |
All times are GMT +1. The time now is 11:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com