Getting embeded Excel worksheets with macros in Word to work
 

I am currently trying to get a macro which works fine in MS Excel to
work as an embeded object in MS Word. I have a feeling it has something
to do with the references. The refernces currently selected a

MS Excel 9.0 Object Library
MS Word 9.0 Object Library
OLE Automation
MS Office Object Library
Visual Basic for Applications
and Normal.

VBA gives the Compile Error: Method or Data Member not found

Any help is greatly appreciated
-Dwight