excel file embedded in a word document needs to be accessed programattically in word VBA. Anyone has any idea..thanks

the object can be accessed using .

activedocument.range.inlineshapes(0).oleformat.act ivate...but here it just opens the excel sheet which i dont want..i just want to excel work in background process so that i can access them on the word vba form

Narendra

You need to create an Excel application object in Word VBA code.

Google or Word forum search for 'CreateObject' - lots of code around.

-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.