Compatibility issue with code writen in excel 2007 and used in 2010

Good day all,

I did a search and could not find what I was looking for. A While back, I created an excel document to automaticaly generate an order sheet when quantities are changed in the inventory form. It all worked fine until today when we updated the computers from windows XP/Office 2007 to Window 7/Office 2010.

Now I found that CalenderControl is not available anymore and that's only a small inconveniance, but the order sheet doesn't work either. I a ''Compile error: Can't find project of library'' error message.

I have a very basic understanding of VBA and Macros, and this exceeds what I know.

Here is one of the several documents I use. It's in french, but the code is in english. How it works, when I change the data in Column F (Qte Disp) it it updates Column G (Qte Comm.). When a cell in Column G is other than 0, it automatically copies and paste pre-established data into the order sheet (named Commandes).

Ambulance (Version 2.7) - Copy.xlsm

I need to add also, I'm 100% new to Office 2010, used it for the first time today at work. All my work was done in Office 2003 and 2007.

I'm not the only user, but if I can follow the procedure above (work for the government, no admin access) I'll do it on all the computers used for these workbook.

Unless there is another way.

Like I feared, I don't have the admin rights on my computer... I'll try removing the calendars...

I tried that I still got an error message... would you mind trying it with the document I liked up top? I think I might be missing some compatibility stuff from the installation process.

It works perfect, and is exactly what I did... I ended up copying/pasting the data in a new macro-enabled workbook. That the only way I found to get rid of the missing library error.

Thanks for your help, that calendar form is pretty handy!