AnsweredAssumed Answered

[Help needed] Macro to add specific text to remarks column in excel list of components

Question asked by Roy Chua on Sep 30, 2017
Latest reply on Oct 3, 2017 by Solid Air

Here's a little background to what I have.

 

I currently have a macro to list in all components of an assembly in an excel sheet.

I will run the macro on the assembly, it will open excel and begin listing every components, thereafter it will reorder that list alphabetically.

The columns of the excel sheet are based on each component's custom property (set using a separate macro).

In general, most components have a blank "Remarks" column.

For certain components, I will put them in a Assembly Tree Folder named "KIT"

 

I need a code that I can add on to my macro, such that it can "detect" if certain components are in that "KIT" folder and add the word "KIT" to the remark column.

 

The problem I have is that I cannot just simply add the word "KIT" to the component's "Remarks" custom property, as these components when used in other assemblies are not "KIT" items, and I don't want them to have the "KIT" in remarks when I run my macro for other assemblies.

Outcomes