Hello.. I have a database that I wrote a while back using Access XP and I inserted Microsoft Excel 10.0 Object Library to automate some features in excel. Well I upgraded to Access 2007 this month and now when I send the database to users they are getting errors cannot find library. I figured it out that when I open the database it automatically updates my excel object library to 12.0. Is there a way to keep 10.0 in there or do I need to install a earlier version of excel on my machine as well so I can use that object library?

Thanks!

You can use Late Binding (so you don't need to have Excel library selected in References)