Without going in to code specifics...

This link explains how to open a file with VBScript. In many cases you can
apply VBScript right inside your procedure or module.

This link should give you some pointers on how to go about opening a
specified file with what ever version Excel you choose (you will need to
specify the path for your version of Excel 2007).

http://www.visualbasicscript.com/m_5...ey_/tm.htm#549

Mark

"Bert" wrote in message
...
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.