How to open Word from Excel or Excel from Word

[radubalmus]

I am kind of a beginner in VBA..
I want to open an Word file, copy something from it and then open an Excel file an paste it there
So my problem is that i don't know how to define Excel as an object in Word VBA or define Word As an object in Excel VBA.

Would greatly apreciate help

 

[PHV]

Have a look at the CreateObject or GetObject functions.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886