Sharing variables between Excel and Word
 

Hi,

I have several Excel workbooks inside a workspace.
These are sending data to Word to create a global document.
The first Excel application activated must do the job of creating the
Word object and sending document fragments to the Word object. E.g. :

Set oWordApp = CreateObject("Word.application")
oWordApp.Visible = True
oWordApp.Selection.InsertFile filename:=strInsertDoc, Range:="", ...

But how can the second Excel write to oWordApp, this is only know
within the first Excel workbook. Can one create variables on workspace
level so to be shared on workbook level ?

Please help me, I am stuck !
Best regards,
Bernard