Below is an example of an Excel macro, which allows you to choose an Inventor Assembly and pull some BOM information in at the active cell position. This example just pulls in the part number, description and quantity but you can modify it to pull through the property information you require.
Click here to download a Text file containing the VBA code that you will need for the Excel macro.
