K
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.
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.