Reorder columns in BOM

[Anonymous]

Hi,

I am using a macro for generating "All levels" BOM for iassemblies.

Please find attached macro for the same.

This macro will generate BOM in excel format.

What I need is a certain collection of columns in a certain order in Excel format.

But when I export the BOM through this macro, the resulting .xls has the correct collection of properties but for some reason it reorders the columns alphabetically; i.e., the first column heading based on alphabetical order shows up in column A. 

So for example my column headings from left to right have been reordered to "Description, File Path, Item, Part Number, Unit Quantity", which does not correspond to the order in my test .xml [Please find attached] .  

Is there some setting I am unaware of to prevent this?

Thanks for any input.

[Anonymous]

Hi,

I have had the same kind of problems and I ended up to solution where I export the BOM data row by row to excel file. This way it works always even if all needed columns are not visible in BOM. Also formatting in excel file is easier. I use template excel file that has some title data also(filled from model). Code copies empty template file and fills the data to xls-file.

This may takes a bit longer time to make the code but it will be better.