Synchronization between MS Word and MS Excel file

[kalyansharma13]

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

 

[Graham Mayor]

The simple way to do this is to make all the edits either in Excel or Word
and link the document from the one which is edited to the other. The changes
are then made simultaneously in both, provided both are open. If they are
not both open, you would need to force an update to the link on opening the
one used for viewing. It doesn't make a lot of sense to maintain two
documents to do the same thing - the scope for them getting out of synch is
great.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[kalyansharma13]

The simple way to do this is to make all the edits either in Excel or Word
and link the document from the one which is edited to the other. The changes
are then made simultaneously in both, provided both are open. If they are
not both open, you would need to force an update to the link on opening the
one used for viewing. It doesn't make a lot of sense to maintain two
documents to do the same thing - the scope for them getting out of synch is
great.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web sitewww.gmayor.com
Word MVP web sitehttp://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Hi Graham,

We can give option user to edit the Word document and Excel will be
updated at the time of closing the word document.

Can you please let me know how we can create link between Word and
Excel file to update/force update?

We need both Word and Excel document as because these two files will
be used by multiple users and few of them are familiar with Word and
few are with Excel.

Can you please let me know that is this synchronization (Word to
Excel) possible by using VBA? If possible then what will be the
approach? How can I do the synchronization using VBA?

Thanks, in advance, for any help and suggestions.

Kalyan