On Mar 17, 2:16*pm, Chip Pearson wrote:
Uncheck the
MISSING reference and all will be right in the world.


Is there a way to load Excel/Word/Office 11.0 object libraries
from VBE running in Excel 2007 and/or programmatically?

I'm telling you that the steps above did not work. Excel would
not save it after being unchecked, it would go right back to being
checked, and it would not save it under a different filename. The
only think that worked is starting over by setting up Excel and VBE
with the right settings and with a new spreadsheet. This was on 2003
I was trying to change it.

In 2007 there was no evident problem, and 11.0 object libraries
were not available under References. Is there a way to load them in
2007 or programmatically?

Thanks, Alan