Access Link to Excel not working

[Central]

I haven't figured out how to make my posts interesting enough for anybody
to answer (on several groups), so stuborn that I am, I'll keep posting
this.


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?

 

[Software-Matters via AccessMonster.com]

Hmm, I would have bet on it being a references problem but it sounds like
you've tried this. Have you stepped through the code a line at a time?
Try adding your code to your post.

 

[Software-Matters via AccessMonster.com]

Hmm, I would have bet on it being a references problem but it sounds like
you've tried this. Have you done a debug and stepped through the code a line
at a time? What line does the error happen on?
Try posting your code with the line that causes the error highlighted.