LeifGund
05-20-2008, 05:38 AM
I have an application that runs OK on excel2002 (excel vers. 10) but breaks in excel 2003 vers 11.
I would like to make a temporary fix until the problem has been solved.
I sub-class Excel.11 and use the workbook_Open event to see if it is my (problematic) type of book, then Open an instance of the excel.10 and open the book in it.
Any ideas on how to due this, and the code below will just open the same excel.11 application.
(Excel 10 and 11 seems to have the same class name).
pseudocode
...
if(isProblematic(WB)) then
Set oExcel10 = CreateObject("Excel.application") ' This is where I need help.
With oExcel10.workbooks.Open(WB.fullname)
end if
...
I would like to make a temporary fix until the problem has been solved.
I sub-class Excel.11 and use the workbook_Open event to see if it is my (problematic) type of book, then Open an instance of the excel.10 and open the book in it.
Any ideas on how to due this, and the code below will just open the same excel.11 application.
(Excel 10 and 11 seems to have the same class name).
pseudocode
...
if(isProblematic(WB)) then
Set oExcel10 = CreateObject("Excel.application") ' This is where I need help.
With oExcel10.workbooks.Open(WB.fullname)
end if
...