2 Replies Latest reply on Jun 6, 2018 4:54 PM by Nilesh Patel

    Importing Multiple Custom Properties From Single Excel File via

    Zack Price

      Hello,

      I am attempting to write a macro that takes data from an excel file and populate several different custom properties.  This seems to exceed the capabilities of the PTB because I am trying to drive the property population from a specific row.  For example, part number is dictated by cell A1, and the material, PO number and other relevant properties are located in cells B1-H1.  The idea would be to have the user define either the row or execute a search for a part number, which would then dictate what values to populate the custom properties with.  I am relatively new to macros so any advice or closely related examples would help.

      Thanks

      Zack