Hi there

I'm looking for a macro that copy the file name XXXXXX_RevXX removes everything behind the "_" and 

make that the PartNo in the custom properties. 

The thing is we used the _RevXX in our file name to name the revisions of the file. But in our BOM list

we want to remove this. Because we have a seperate column for our revisions. 

So i thought the best way to do this is with a macro, or is there another solution in such a way we never have to duplicate it. it should be automated.

Dennis