I am a practicing radiologist. We enter patient information such as Name, date of birth, number (patient ID), referring physician's name, and date of the study at the front desk in MS Excel 2003. Is there any way to export this data in real time to MS word 2003, on a network laptop? If possible, can somebody help me with a script or show me how to do it? Any help will be greatly appreciated.
migrated from stackoverflow.com Aug 13 '10 at 12:19
This question came from our site for professional and enthusiast programmers.
I believe if you copy the data you require in Excel and then use the Paste Special option in Word you can paste it as a link so changes to the excel document are mimiced in the Word document.
EDIT: In fact this microsoft page should be right up your alley.
EDIT 2 : This link should still work here The aim is basically to copy the data in Excel and then use the Paste Special functionality to paste a link to the data. This can be updated periodically or when the file is opened. Hope this helps and thanks @pnuts for finding the dead link.