Hi,
For data exchange from Excel 2003 files to Word (no matter which Word version) the following code works fine.
Code:
Set db = OpenDatabase("C:\Test\Book1.xls", False, False, "Excel 8.0")
I often used (and still use) it. Source:
http://word.mvps.org/faqs/interdev/xltowordwithdao.htm
But I completely fail when trying to use it with Excel 2010.
Code:
Set db = OpenDatabase("C:\Test\Book1.xlsx", False, False, "Excel 14.0")
With Excel 14 this connection fails with an Installable ISAM errror. Same if I try "Excel 12.0".
Conrol Panel > ODBC driver information says "MS Excel Driver (xls, xlsx, ...)" is installed.
An idea what's going wrong here? I'd really like to continue importing data this way
...
Thx
NP