Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Excel 2003 in Excel 2007
Hi Guys,
I have an Excel 2003 workbook which is to be kept at 2003. Some users have Excel 2007 and when they come to save it, they have to respond to a message about the versions. How can I close and save the workbook programmatically from a computer running Excel 2007 ensuring that it is saved in Excel 2003 format? Many thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Excel 2003 in Excel 2007
Hi Guys,
Sorry I didn't really make it clear. I'm talking about saving the changes when closing the workbook programmatically - "Thisworkbook.close Savechanges:=True" Many thanks. "Libby" wrote: Hi Guys, I have an Excel 2003 workbook which is to be kept at 2003. Some users have Excel 2007 and when they come to save it, they have to respond to a message about the versions. How can I close and save the workbook programmatically from a computer running Excel 2007 ensuring that it is saved in Excel 2003 format? Many thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Excel 2003 in Excel 2007
Libby
If its an .xls then your line below will work fine. The only issue you may have is the compatibility checker flagging up potential concerns. If you need to saveas then you will need to specify the file type (xlExcel8 - 56) Cheers Simon Excel development website: www.codematic.net Libby wrote: Hi Guys, Sorry I didn't really make it clear. I'm talking about saving the changes when closing the workbook programmatically - "Thisworkbook.close Savechanges:=True" Many thanks. "Libby" wrote: Hi Guys, I have an Excel 2003 workbook which is to be kept at 2003. Some users have Excel 2007 and when they come to save it, they have to respond to a message about the versions. How can I close and save the workbook programmatically from a computer running Excel 2007 ensuring that it is saved in Excel 2003 format? Many thanks in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Excel 2003 in Excel 2007
Thanks Simon. There was no problem.
"Simon Murphy" wrote: Libby If its an .xls then your line below will work fine. The only issue you may have is the compatibility checker flagging up potential concerns. If you need to saveas then you will need to specify the file type (xlExcel8 - 56) Cheers Simon Excel development website: www.codematic.net Libby wrote: Hi Guys, Sorry I didn't really make it clear. I'm talking about saving the changes when closing the workbook programmatically - "Thisworkbook.close Savechanges:=True" Many thanks. "Libby" wrote: Hi Guys, I have an Excel 2003 workbook which is to be kept at 2003. Some users have Excel 2007 and when they come to save it, they have to respond to a message about the versions. How can I close and save the workbook programmatically from a computer running Excel 2007 ensuring that it is saved in Excel 2003 format? Many thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set Excel 2007 as default to save files in Excel 2003 .xls format | Setting up and Configuration of Excel | |||
Excel 2007 crashes when perform SAVE AS to Excel 97-2003 | Excel Discussion (Misc queries) | |||
Excel 2007 save as Excel 2003 problem | Excel Discussion (Misc queries) | |||
How to save Excel 2007 compatible with excel 2003 | Excel Discussion (Misc queries) | |||
Unable to save modified Excel 2003 worksheets using Excel 2007 | Excel Discussion (Misc queries) |