I'm not sure what changed, but somehow I started getting this error
"Class Does Not Support Automation etc"
in an Excel VBA app.
It took more more than an hour fiddling with Tools | References and playing in the Debug window. Also I started downloading MapPoint 2004 (yes we are still using that for some projects!) from MSDN before I finally realized just doing
Just thought I would share.