Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
save as .xls (97-03 format) with code | Excel Programming | |||
Code Date Format Depending on Computer format | Excel Discussion (Misc queries) | |||
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
Placing a code before Save & Save As | Excel Programming |