Can't find Project or Library

[ExcelWombat]

I have an Excel 2007 spreadsheet that works perfectly but will not work with Excel 2010. One of the lines of code that is now failing is -

ResultsWindow.PostTax.Value = Format(0, "$* #,##0")

All this is trying to do is to format a number in a field on a Userform but I get the message "Compile Error: Can't find the Project or Library". From what I have been able to find on the internet, this is a problem with MS SOAP v3 not being compatible with 64 bit systems. In the program references, Microsoft Office SOAP type library v3.0 is shown as missing.
Does anyone have a simple fix for this type of problem. Thanks.

[royUK]

Have you tried removing the check mark in the reference box where it is showing "MISSING"?

Hve you a Calendar control on your Form?

[ExcelWombat]

I removed the check mark as you suggested and that fixed it. How easy is that!
Thanks for your help.

I had found a workaround and that was to preformat the field and then transfer it to the Userform as Text so that the formatting was preserved.
Thanks again.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save