3 Replies Latest reply on Feb 9, 2018 10:53 AM by Matt Bieringer

    macro for extracting mass properties to Excel

    Louise Manfredi

      Hi everyone,

      I have been reading through the forums for days on this and cannot find a good starting point.  I do not have a lot of programming experience, so you will have to talk to me like I know nothing.

       

      To speed up my grading, I would like to run a macro through Excel that pulls out mass properties from, say 90 files, without opening them.  I would also need to log the creator of the file.

       

      Is there a simple way to do this?  I don't have admin rights (sigh) on my computer, so installing something new should be a last resort.  I have premium SW 2017.

       

      Any thoughts would be really helpful!