Could not load object because it is not available on this machine

Hey all,

I have created an excel 2000 Macro-Enabled workbook on my Windows XP sp3 machine. The workbook can be downloaded here:

Project Assumptions Template

Whenever anyone in my office tries to open the file, the following message comes up:

"Could not load object because it is not available on this machine"

Hitting the debug button will bring up the Workbook_Open event sub, with the error being thrown when excel tries to use basic VBA functions such as Lcase(), len(), etc().

I think that perhaps the issue is related to the MS12-027 security patch issues described here, however none of the solutions that have been suggested for this problem seem to work.

If someone can figure this out, I will be most grateful.

-Tom

i think we have the same problem, i'm using windows XP before and when our MIS upgraded this to 7, my excel vba got this same error message.