C
Central
Greetings,
I support an old, convoluted Access 2003 database that calls Excel to
load a file, perform some horrendous activities, then return to Access. All
works fine with Excel 2003, but the Excel 2007 quits without performing
myExcel.run, saying wrong number of parameters, which isn't the case. (The
myExcel object is created from createObject "Excel.Application").
For complex reasons (mostly financial), we must upgrade Office to 2007, but
not Access, so I can't just convert the DB to Access 2007. I deleted the
Excell 11 References (except Access, obviously) and kept the Office 12
Excel ref. I'm thinking this is simple, maybe a reference issue, but I
don't want to play any more guessing games!
Ideas?
I support an old, convoluted Access 2003 database that calls Excel to
load a file, perform some horrendous activities, then return to Access. All
works fine with Excel 2003, but the Excel 2007 quits without performing
myExcel.run, saying wrong number of parameters, which isn't the case. (The
myExcel object is created from createObject "Excel.Application").
For complex reasons (mostly financial), we must upgrade Office to 2007, but
not Access, so I can't just convert the DB to Access 2007. I deleted the
Excell 11 References (except Access, obviously) and kept the Office 12
Excel ref. I'm thinking this is simple, maybe a reference issue, but I
don't want to play any more guessing games!
Ideas?