Interfacing MS Word 2000 with a Visual Basic 6.0 application (Add-in?) - *Resolved*

[KayJay]

The following is what that needs to be done and I would like to request assistance as to the approach, tools and/or code since I have no experience in working with MS Office (from the programming side, of course ) or with creating Add-Ins.

1) The end-user opens an existing word document
2) (S)He highlights some text (could be within a table as well)
3) Clicks a button or presses a key combination
4) The highlighted text changes to the text recieved from below.

........5a) The text as highlighted above is recieved by my VB application along with information on the selected text's font (name, size, bold, etc.)
........5b) The information so recieved is parsed by my application in correspondence with my database and a new string is generated comprising a totally different text of a different font, size, weight, etc.
........5c) The new string is to replace the highlighted text along with the new font, size, etc.

6) There should be no code at all in the "Macros" section of the Document
7) As of now I would be content with MS Word 2000. But it would be extremely helpfull if the above can be made to work in MS Excel 2000 and other products of the MS Office 2000 suite or is also functional in older versions of MS Office

TIA

Regards

Kaushik Janardhanan