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