Controlling Word Or Excel (Resolved)

Hi,

I've done it in VB no problem. Create an object assign it to application.Word or application.excel and away you go. However, in VBA (MS Access) Object function/type doesn't exist.

Does anyone know how to get an object of Excel/Word in VBA (Access) ? It has to be simple cause I did it before in Access for office automation... but I think I need a references...which?

Thanks in advance

Vince


Hmm seems object is there... ta anyway

That is what you're missing, the references.
Tools Menu in Access > References >

• Microsoft Excel x.0 Object library
• Microsof Word x.0 Object Library