real time synchronize between excel word

[dorabajji]

Hi,
Is it possible in vba to automate sync between excel and word.. if I type something in cell it should also update in word,even if it is closed like a real time update.
Is possible through macro

[6StringJazzer]

Do you need two-way synchronization? If you are only updating the Excel file, the way to do this is with a link, rather than a macro.

[dorabajji]

Hi Jaz,
No i saw a video, in youtube.. and it was related to sync to word -virtualpro for office ..
In that the updation in word file was taking place simultaneously when excel was updated..
I only know to create a button and to update the excel and click to make changes in word through vba or do mail merge kind of stuff..
This i was not getting, whether it was an add in or is it possible like that..

and between how will you link word and excel.. Two excel sheet you can do.. but how in word.. am not getting you.