B
Bert
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.
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.