Here are some links to explore regarding VSTA/O and VBA interoperability:
MSDN Magazine
MSDN Channel 9
VBAinteropWithVSTO_Moth.zip