I've made an example for excel. I used the following input:
Example read 50 rows from excel (3 columns):
It prints to message box, color and group name with correct thickness. You can use array colors, thicknesses and groupsIds to update group titles in your macro:
If you have difficulties in referencing to excel in Femap let me know.
Thanks a lot. This really helps make somewhat snese of it.