 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008ODBC in Excel 2007 to work in Excel 2003
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. >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.  SignatureDick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.