Cannot find project or library -- error message

[mcfranczyk]

I am getting the following error message when I try to run my macro.

Cannot find project or library

It seems excel cannot find "Format"

It also can't find "Date" and other normal references. What could have happened. It worked last night!

 For Mnth = 1 To 12
        UserForm1.lboxMnth.AddItem Format(MonthName(Mnth), "mmmm")
    Next Mnth

EDIT:

Just looked in the reference library and found this...

MISSING:Microsoft Calendar Control 10.0

How can this be fixed??

 

[mcfranczyk]

Uh, sorry to burst your bubble, but I'd put money on the fact that IT departments rarely do full installs. They do what's quick and easy and gets people up and running with minimal downtime. The chances of people needing a complete install are very slim - welcome to the exception to the rule.

I have a workbook that I made for somebody for this exact reason today. Kinda funny actually. And for this EXACT reason. Truly ironic, but if only for myself.

Anyway, if you'd like I can email it to you tomorrow. Just pm me if you'd like me to send it. It's the only thing the workbook has on it and the code is commented fairly nice (imho). Or I can post to the board if you'd like.

I highly recommend you don't use anything fancy, such as the DTPicker, in lieu of you sending this to 5 continents. I would feel horrible for you having to do so much extra work and troubleshooting.

I'll have to check, because we have a univeral build that goes on all desktops, so things should be standardized.

I'll contact you tomorrow, though.. thanks for the help