HELP - BOM Export to Excel Macro/iLogic

[AnthonyB7]

Hi everyone, 

I have zero experience in coding and I have be luckily enough to get some very good help in this forum. I am trying to automate by macro/iLogic in exporting BOM into Excel and I do not know where to begin. I have copied some codes here that I think are very useful but for some reason I am getting errors and I do not know how to debug them.

All I wanted to do is to export all the parts into a BOM in an excel format but also structure it to match the columns and rows that our purchasing department is used to.(see Sample BOM structure below).

I also would like to add this at the very top of the the BOM. 

[A.Acheson]

Can you supply the codes your using and a list of the column headings you would like to export? The pictures are OK for a start but it would be great if you can supply as much info as possible to cut down on time spend by someone helping to diagnose issues. There is two approaches people use.

1. Export all the BOM from the assembly in its raw form then delete/shuffle the columns not required after export. 
2.  Do not use the standard BOM export method but loop through each row of the BOM and send to an excel file. It can be slower to export depending on the size of the over all assembly. 

[AnthonyB7]

I actually got rid of the codes that I have been testing out since I have no clue on how to debug them. I preferably would like to start fresh on the code and get help in creating one. I would like to use the 2nd approach to export BOM to loop through each row and send to an excel file.

[A.Acheson]

The second version is the harder of the two to implement as every iproperty your trying to export has to be hardcoded into your code. Are you exporting to a specific template with the excel columns allready set up? If so can you please share a basic data set. I personally would prefer the straight export method 1 and manipulate the Column headers and simply delete the columns after. 

Here is a post with the first approach that works well and easy to understand.