Formatting Excel Links in Word Doc
Posted on 2004-11-16
I have a rather simple Word doc that is updated with information contained in a variety of cells in Excel. Links work just fine...used copy, paste special, paste link, formated text...I went to each link in the Word doc, double clicked to highlihght the linked text, did a format with font=Arial, size=12, style=bold...looks good. saved. When I update the info in the XL cell(s) and it updates in Word just fine, but formatting is lost...most noteably, style is regular, not bold. Is there a simple vba routine that can set all formatting for fields when updated?