Hi,

I have Excel 2003 and 2007 installed on the same machine.

I'm trying to automate Excel 2007, but everything I seem to do ends up in
Excel 2003.

I have a file (XLSX) which was made in Excel 2007 and I'm trying to open it
programmatically. But since the file has more than 65K rows, I keep getting
a trunction warning and after the file opens I have only the first 65K rows.

I use late binding. I tried acquiring the Application object using
Excel.Application and Excel.Application.12 prog IDs. I also tried early
binding (adding the Office 12 library and the Excel library) but they all
result in the same problem.

Any idea would be greatly appreciated.

Thanks!!!

Bert.