The panel properties are not showing properly in tables but showing in the Object Inspector.

[muhammad_hasan88NXQ]

Hi Guys,

I have devoleped VBA modul to automaticaly create panle propterties and assign to the selected panles in Robot from excel. But when i assign panle propterties to the panel through VBA some properties like subgrade modulus are not refelecting in the table but when i click the panel the property is showing in the object inspector.

Please help me resolve the issue.

Thank you

[Stephane.kapetanovic]

hi @muhammad_hasan88NXQ 

Have you saved and refreshed? Is the data genuinely missing or not being displayed? What happens when you generate the calculation model? Are there any messages during the generation process? Does the information appear afterward?

Best Regards

[muhammad_hasan88NXQ]

Yah I have saved and refreshed and checked, It was still missing. But there were no error during analysis also and results where matching with same model done manualy. Only thing is the panel propties are not showing in the tables. I got a work around, I just copy the Panel thickness from the robot table, paste in a excel and repaste it the robot panel table. The robot refreshes the tabel propreties and then it was showing all the properties right.

[Stephane.kapetanovic]

hi @muhammad_hasan88NXQ 

It would be appreciated if you could share the section of your code that illustrates how the material is assigned to the thickness. When dealing with the Material label, utilizing the CreateLike method might be a more optimal approach.

Best Regards

[muhammad_hasan88NXQ]

I have attached the whole excel where you can create material prop, Panel section, and assign it and apply 3p contour loading. The same thing is happing for panel loading while updating the exsisting loading, if we change the contour and panel numbering and update it, In the robot the changes are reflecting in the View but not in the tabel. Please help.

[Stephane.kapetanovic]

hi @muhammad_hasan88NXQ 

in module 2, sub MaterialLabel, use the createlike method as discussed before.

Best Regards

[muhammad_hasan88NXQ]

Can you be more specific, and I face isuues when modifing loads or appling panel properties to the robot model through VBA. Thanks for your help

[Stephane.kapetanovic]

[muhammad_hasan88NXQ]

Hi Stephane, 

         Thank you for your support & you are very helpful and patient with me.

I need your help to incorporate the following feature in my code. In my excel the module 6 Sub UpdateNLoad case Only updates load and contour values. as seen in the snap.

Now I want to include update panel list and to set selection to auto detect panels in side contour please help.

[muhammad_hasan88NXQ]

Hi Stephane, 

I need your help to incorporate the following feature in my code. In my excel the module 6 Sub UpdateNLoad case Only updates load and contour values. as seen in the snap.

Now I want to include update panel list and to set selection to auto detect panels in side contour please help.

Thank you for your support & you are very helpful and patient with me.

[Stephane.kapetanovic]

replied in private message

[muhammad_hasan88NXQ]

Thank you stephane for your support, figure out my older post from Romanich reply from following post

Solved: (API) macro for updating panel contour loads from Excel - Autodesk Community - Robot Structu...

Here is my modified excel for reference, It may be of use to some one.

[Stephane.kapetanovic]

thank you for sharing