Access 2003 db's & problems exporting query to Excel

[ksp8]

I have a large Access 2003 db with lots of macros that run simple
queries and then export the data to Excel. We have just started
upgrading the user community for this db to Office 2007. The first
person that was upgraded is no longer able to output the query results
to Excel (receive an error message that data is in wrong format -
Biff8). We modified each Macro to output the query results to Excel
97-2003. THe Office 2007 users can now export the data properly but
the Office 2003 users now get an error message. They would like to
keep the output format as Excel. Is there a solution that will allow
both Office 2003 and Office 2007 users to output the query results to
Excel during this upgrade transition phase?

Thanks.

 

[Piet Linden]

I have a large Access 2003 db with lots of macros that run simple
queries and then export the data to Excel.  We have just started
upgrading the user community for this db to Office 2007.  The first
person that was upgraded is no longer able to output the query results
to Excel (receive an error message that data is in wrong format -
Biff8).  We modified each Macro to output the query results to Excel
97-2003.  THe Office 2007 users can now export the data properly but
the Office 2003 users now get an error message.  They would like to
keep the output format as Excel.  Is there a solution that will allow
both Office 2003 and Office 2007 users to output the query results to
Excel during this upgrade transition phase?

Thanks.

You can write a function like this to return the version of the
Application, so then you can branch and write a separate routine for
2003 and 2007.

Condition:
GetAppVersion()="12.0" '--- 2003

GetAppVersion()="13.0" '--- 2007

'--put this in a public module.
Public Function GetAppVersion() As String
GetAppVersion = Application.Version
End Function