I'm trying to hold Rich Text Formatted text in a series of cells in an excel spreadsheet and be able to edit them as if they were word objects. I have a VBE form with an InkEDit control on, so I can display the RTF within the form ok. However, I would also like to be able edit the text, and rather than reinvent a UI with buttons and trapping keypresses, I figured just pasting the cell contents into Word should give allow the end user to use Word to format and edit the text.
The questions I have are:
1. The best way to get the data from Excel into the word doc (I have a blank document with the correct styles in place to use for editing) the text is in an InkEdit control and also in a cell.
1. How to get Excel to wait until the user has finished editing the word document?
2. How to pull back the data and store it back into the cell?
TIA
Bookmarks