R
Richard Hannah
Developing in Access 2003 for a mixture of 2003 and 2007 users I am confused
at the file formats to select in "outputto" instructions in macros.
In Access 2003 I select Microsoft Excel 97-2003 (*.xls) format which appears
to work in some instances of 2007.
On others it does not - selecting Excel97-Excel2003Workbook(*.xls) when
amending the macros in 2007 works but is not on the list for 2003 (but works
in 2003)
Why? What is going on? Is It Me?
Seriously - how can I find a consistant export format that allows Access
2003 & 2007 to use the same code and is amendable in both versions?
at the file formats to select in "outputto" instructions in macros.
In Access 2003 I select Microsoft Excel 97-2003 (*.xls) format which appears
to work in some instances of 2007.
On others it does not - selecting Excel97-Excel2003Workbook(*.xls) when
amending the macros in 2007 works but is not on the list for 2003 (but works
in 2003)
Why? What is going on? Is It Me?
Seriously - how can I find a consistant export format that allows Access
2003 & 2007 to use the same code and is amendable in both versions?