Error (Excel 2000)

[HUHandEH]

Hi all,

I am getting an the Error "Can't find Library" I'm a bit confused as to why, I don't get the error on my own machine, but when I copied a template to another PC it couldn't find the Library. I read the help file, but that didn't help. Any ideas?

Thanks Darryl.

[HansV]

Do the following on thePC where the error occurs:
- Open the template.
- Activate the Visual Basic Editor (Alt+F11).
- Select Tools | References...
- Most probably, one of the references starts with MISSING.
- Note which reference it is, in case you need it later.
- Clear the check box for the MISSING reference.
- Click OK.
- Test if the template works now.
- If not, you may have to find the missing library - it may be installed in another folder than on your own PC, or perhaps it isn't installed at all.

[HUHandEH]

Hi Hans,

I did what you said, but what it was referring to was "format" and also Msgbox Ucase("message"), "UCASE", What Library would I need to pick for those two?

Or should I have Microsoft office installed again?- it makes me curious, cause I have a calendar control on a form that didn't load on another computer, got a message "Could not load object on this computer" but loaded on two out of 4.....

Thanks,

Darryl.

[HansV]

The Microsoft Calendar control is not installed with the standard version of Office, it comes with Microsoft Access, i.e. with Office Professional and Office Developer Edition. So a form with a calendar control will not work on a PC with a standard version of Office.

[HUHandEH]

Thanks,
Hans.