I am trying to built a tool in Excel-VBA to help me with creating objects in Femap trough API. I am a new to this and struggling to find a fast method to create nodes. I do have a slow node creation method based on femap.fenode object, but this method is very slow for large number of nodes.
Now I am trying to use the PutAllArray method to try to speed things up, however I cannot get it to work. It does run, but does not create any nodes.
The code I have written in VBA is attached in PutAllArray test.pdf
Also I have included a snip of the excel worksheet where the input is being taken from.
Any help would be much appreciated.
Solved! Go to Solution.
I looked through code and I think I found your error. It seems that you have declared all of your input values as arrays, but the FEMAP API does not take arrays. It instead uses Variant objects to pass through arrays of data. Another issue I found is that you seem to be using the word false in your excel sheet and not a boolean value. Make sure that the excel True/False are in there boolean form or instead just use 1 and 0 for true and false respectivley. I fixed your code and attached in it a text file below.