Synchronization between MS Excel and MS Word file
 

Hi,

I am trying to synchronize two documents (one in MS Word and other in
MS Excel) with same format by using VBA. Both documents carry the same
information. If the user changes/modifies something in Word document
then at the time of closing the Word document all changes/modification
should be reflected to Excel file and same logic need to apply for
reverse scenario when the user changes/modifies something in Excel
file then at the time of closing the Excel file all changes/
modification should be reflected to Word document.

Both the files contain Text (formatted like Bold, Italic and
Underline), Bullet lists, Images and Tables.

In one document –
1) Text format can be changed
2) Bullet lists can be increase or decrease
3) Image can be modified, deleted or new Image can be inserted
4) Table can be modified (Row and column can be increased or decreased
and text can be changed)
5) New table can be added

For the entire above situations the modification should be reflected
to the other document

In Word file there are some grouping of text (I am mentioning here
Sections) like
• Section 1
o Sub-Section 1.1
o Sub-Section 1.2
• Section 2
o Sub-Section 2.1
o Sub-Section 2.2
• Section 3

Under each Section there will be some Sub-Sections. Within each Sub-
Section there may be formatted text, Bullet list, Image and Table.

For each Section in Word file there is an Excel Sheet in Excel file
and all contents of one section in Word file exist in the
corresponding Excel sheet in Excel file.

MS Word and MS Excel file should be either Office 2003 or Office 2007
version.

How can I do the synchronization using VBA? What will be the approach?

Thanks, in advance, for any help and suggestions.

Kalyan