ODBC in Excel 2007 to work in Excel 2003

[John Meyer]

I developed spreadsheets in Excel 2007 that accesses QB data. I need to have
Excel 2003 computers access & refresh the data, then run reports. I also
need to know how to have 2003 access and use the macros I developed for the
sheets. Where are the macros and ODBC access setups stored if one is on the
network.

 

[Dick Kusleika]

On Tue, 27 May 2008 14:44:02 -0700, John Meyer <John

I developed spreadsheets in Excel 2007 that accesses QB data. I need to have
Excel 2003 computers access & refresh the data, then run reports. I also
need to know how to have 2003 access and use the macros I developed for the
sheets. Where are the macros and ODBC access setups stored if one is on the
network.

If 2003 has the converter installed, it will automatically convert your 2007
file. If not, you'll have to save it from 2007 down to 2003.

In either case, the QueryTable object is unchanged between versions, so
refreshing them should not be a problem. Whether your macros will work
depends on if they access features that are new to 2007 (conditional
formatting, themes, rows > 655536, etc.).

The macros and ODBC information are stored with the workbook.