Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO connection not opening in Excel 2003
Hi, I've been setting the following connection string with no problems in VBA
in Excel 2002: cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ThisWorkbook.Path & "\" & ThisWorkbook.Name & ";Excel 8.0;HDR=No;IMEX=1;" However, this causes my Excel 2003 to crash horribly when the connection is opened. connectionstrings.com gives the following: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=No;IMEX=1"; I've tried including the "Extended Properties=" and tried most permuations of quote marks and Chr(32) - all just make the VBA stop in its tracks rather than crashing Excel. Anyone got any ideas? Do I need a different connection string for Excel 2003? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening a PDF in Excel 2003 | Excel Discussion (Misc queries) | |||
ODBC connection trough Visual Basic in Excel 2003 | Excel Programming | |||
DB connection 2003 vs 2007 | Excel Discussion (Misc queries) | |||
opening excel files from access 2003, win xp, office 2003 | Excel Discussion (Misc queries) | |||
How do I set up my ODBC Connection from AS/400 file in Excel 2003 | Excel Discussion (Misc queries) |