Question
Run Excel Macro -AFTER- Creo BOM Export? - YES!
OK - So this is a shameless plug for Nitro-BOM ...
BUT..... There is a nice example within this video regarding an Excel Macro to automatically transfer Excel Data (Assembly Number, Cost Summary and BOM Tables) to Microsoft Word Document and save off a new version --- e.g. Customer Quotation based on CAD Assembly Data and Cost Summaries.