This solution requires a few clicks, but it may get you where you need. A macro could probably be made from these steps, but I am not a macro guru...
From the model, you can Insert, Tables, Bill Of Material...
Once configured how you want, RMB on the BOM, Save as, then select the Save as Type...