I have seen that it is possible for a SharePoint web part to merge data from a list into a Word document. But, Is it possible for an Excel file, or Word file, using Visual Basic macros, to find and get data from a specific row in a SharePoint list? For example, the data would be brought into the Excel or Word file - filling in cells of a form.
What are some of the hurdles to get over to achive that?