Im trying to create a macro to create multiple fatigue studies with multiple forces and time series.
I have been successful in creating the studies and the fatigue events but my problem is getting my amplitude and time series data imported correctly.
I am using this example that i want to modify to create the different events:
I want to import my data either from a .txt file or most preferably an excel file. I have no problem to import from excel its just how to get it into the right array format.
This is where the event is created and i want the data from a file instead of written directly in the code.
PointsX = Array(0, 1, 2, 3, 4, 5, 6.25714, 7, 8.3846, 9, 10)
PointsY = Array(0, 11, 21, 33, 44, 21, 66.25714, 77, 88.3846, 99, 109)
Set FatigueEvent2 = FatigueOptions2.AddFatigueEventForVariableAmplitude("Ready_Static", -0.002, 1, (PointsX), (PointsY), 0, 1#, errCode)
I would want to write something like this but it is not working:
PointsY = exApp.Worksheets("fatiguedata").Range("B2:B12")
Anyone have any clues how to get this to work?