Company has just centrally, updated all PCs from Office 2003 to Office 2007 (Word/Powerpoint/Excel).

This has caused a problem for a few PCs that have a VB6 program on them that creates Excel files via ODBC - and of course these are important files!

Now they get an "External table is not in the expected format" error during export.

I am not a VB programmer, but have found the old code and it has a connection string  of:
 "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & TheFile & ";Extended Properties=Excel 8.0;"

(where TheFile =Excel).

I assume that loading Office 2007 has changed the ODBC drivers.

Which would be the best way to get over this problem?

Many thanks  

Hi,

I don't know offhand.  But you'll get a much better response if you post your question in forum707: VBA Visual Basic for Applications (Microsoft).

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}