I want to use an excel file as a data source for an ms word document:
- More than one sheet (table) of the excel files need to be displayed in the word file
- Formatting of the tables in MS and excel must look different. I want to use excel to input data and word to create a report of the data.
So far I have a word document and an excel document. The first sheet of the excel file appear in the document by: Insert -> Object -> Excel file (using link to file).
What is missing is too insert an object (as above) to the same file but so that the second sheet in the excel file is displayed in word.
Even better will be if the sheet to displayed is identified by sheet name.