Can a excel macro automate a report of a solid edge assembly file

[Nodski]

I would greatly appreciate to be advised of the code required, that is if it can be done. The purpose of this is for BOM generation.
Manual procedure for this is right click on the assembly file (.asm ) and then select the command report.

Thanks in anticipation
Nodski

 

[beachcomber]

You can use a VB macro to write data to an excel file, so you should be able to use the vb built in to excel to extract the BOM data from the assembly and import it.
If was doing it I would opt for the first option - do the macro in VB and use it to write into an excel file.

bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.

Where would we be without sat-nav?

 

[Nodski]

Hi Beachcomber,
Thanks for your response...
Excel does not record outside of office or i am missing something ?