Hi all,
I'm finding a way to export data from selected cells in an Excel workbook into a Word doc (which I hope to lock). The cells containing the data to be exported into the Word file are basically everywhere in the Excel workbook. I've tried the
- Paste (Link and Merge Formatting),
- Paste Special (Unformatted Unicode Text), and
- Paste Special (Ms Excel Worksheet Object),
methods but I realised none of these will auto update the changes once the Word doc is locked.
Is there anyway to go about updating the data in the Word doc automatically each time the Word doc is opened and at the same time lock the Word doc so that it does not get tampered with?
Below is a sample of some of the info to be exported from the Excel but there is more info in the same workbook.
1.png
And a sample of some of the info to be input into the Word doc.
2.PNG