I would like to read information from a table in Excel and input that information into a pre-formatted table in Word. I would like the user to be able to select an Excel file, tab and range of cells to be transferred to the Word document.
So far I can have the user select an Excel file using the FileDialogFilePicker. I am having trouble selecting a range of cells from this file because the usual Excel Methods are not available in Word VBA.
Any ideas, suggestions or directions? Thanks!