Wondering About Compatibility Problems With Access XP and Excel 2007

[Baggie]

Hello all,
Just wondering if anyone has experienced anything like this. I have an XP database where I have written some VBA code to create, manipulate and then send out (via Outlook) some Excel spreadsheets. It worked perfectly last month when our company had Excel XP. This month we have been forced to updgrade everything (except Access, since it's "unsupported") to Office 2007. Now, when I try to run my code, Access just crashes (The one that says an error has occurred and Access needs to close,Send error report to MS and all that). So, what I'd like is some advice. Should I beg to upgrade to Access 2007 (and will that solve my problem? Or create more problems?). Or should I ask to have back a copy of Excel XP? My suspicion is that my reference to Excel (MS Excel 12.0 Object Library) may be the culprit. The funny thing is that I can output a query to an Excel sheet via the regular interface toolbar. ???
I'd appreciate someone's expert advice. I have to send out over 300 spreadsheets that are overdue and unless I can solve this it's going to be a long manual process.

 

[MajP]

You should probably consider late binding for your automation

http://www.granite.ab.ca/access/latebinding.htm

I cannot promise you that is the problem, but that would be my first approach.

Can you post the problem code?

 

[Baggie]

MajP
Thanks for your response and the link to the article. I got it resolved by upgrading to Access 2007 and the program works fine now.