Hi,
I have both Excel 2003 and Excel 2007 installed on my machine. I'm trying to write vb.net code that opens the Excel.Application object for 2007. I've even try to early bind to the 12.0 Excel Library but every time I turn the visible property on after creating the object, the 2003 version is loaded.
Has anybody had this problem and does anyone know of a way around it? I'm trying to load a 2007 workbook (xlsm extension) and then, write code that refreshes the workbook, saves, and quits the workbook.
Any help on this matter would be greatly appreciated.
Thanks.
Robbie
I have both Excel 2003 and Excel 2007 installed on my machine. I'm trying to write vb.net code that opens the Excel.Application object for 2007. I've even try to early bind to the 12.0 Excel Library but every time I turn the visible property on after creating the object, the 2003 version is loaded.
Has anybody had this problem and does anyone know of a way around it? I'm trying to load a 2007 workbook (xlsm extension) and then, write code that refreshes the workbook, saves, and quits the workbook.
Any help on this matter would be greatly appreciated.
Thanks.
Robbie
