(API) macro for updating panel contour loads from Excel

[Rafal.Gaweda]

First import contour loads (automatically for all simple cases)

Then you can change values in Px1..Pz3 columns, and X Y Z columns and run Update

Do not make any change in Case, Record, Object List or Number of contour points columns (or modify macro by your own to consider these or other changes you want)

[Anonymous]

That's what I did but the warning remains.

The file attached to this message is my excel-vba file. load case : line 170 .

Can you please help me finding what i'm missing?

[Rafal.Gaweda]

Hi @Anonymous 

I do not see any problem.

Line 170 is either empty or as comment ,depending on which line is line 1.

[Anonymous]

Please try to lunch the program et and then lunch the calculs to see.

I see no error from line 170 to line 208(laod case "longine") but still i got a warning for that load

[Rafal.Gaweda]

Hi @Anonymous 

Local vector for contour must be set using SetVector() function

ex. 

LoadRecCont.SetPoint 1, 0, donnee3, haut
LoadRecCont.SetPoint 2, 3, 1 + donnee3, haut
LoadRecCont.SetPoint 3, 3, 1 + donnee3 + donnee4, haut

LoadRecCont.SetVector 0, 0, 1

[neeraj.khatri]

I am trying to use API for contour load modification,  I used Getcontourloads tab to get contour load data which is till row 551 in excel.

I am trying to add a new load by copying rows 547-551 to 552-555 and modifying Record (column B), Pz1 (column F) and X,Y,Z values. When I run Update_Loads tab it gives a runtime error. Can you please help? I am attaching a screenshot..

[Rafal.Gaweda]

Hi @neeraj.khatri 

This macro updates ONLY imported loads.

You need to modify it by adding some code to create load records.

[NNBL]

I want to change the coordinate also along with contour definition.  Any VBA marco for it?