I am using an excel macro for Dymola simulation. It worked well with Dymola 2020x or 2022x. After upgrading it to 2024x, this excel tool doesn’t work. I created simple dymola model and excel macro like this.
//Dymola model
<code>model Unnamed2
parameter Real x=1;
Real y;
equation
y=2*x;
annotation (Icon(coordinateSystem(preserveAspectRatio=false)), Diagram(
coordinateSystem(preserveAspectRatio=false)));
end Unnamed2;
</code>
<code>model Unnamed2
parameter Real x=1;
Real y;
equation
y=2*x;
annotation (Icon(coordinateSystem(preserveAspectRatio=false)), Diagram(
coordinateSystem(preserveAspectRatio=false)));
end Unnamed2;
</code>
model Unnamed2
parameter Real x=1;
Real y;
equation
y=2*x;
annotation (Icon(coordinateSystem(preserveAspectRatio=false)), Diagram(
coordinateSystem(preserveAspectRatio=false)));
end Unnamed2;
//Excel macro
<code>Sub ExcelMacro()
Cells(1, 1) = Application.DDERequest(Application.DDEInitiate("dymola", "xxx"), "ModelicaString:x")
End Sub
</code>
<code>Sub ExcelMacro()
Cells(1, 1) = Application.DDERequest(Application.DDEInitiate("dymola", "xxx"), "ModelicaString:x")
End Sub
</code>
Sub ExcelMacro()
Cells(1, 1) = Application.DDERequest(Application.DDEInitiate("dymola", "xxx"), "ModelicaString:x")
End Sub
If I run excel macro after simulating Dymola model in Dymola 2022x, then cell A1 returns 1.
But it returns #REF! if I use Dymola 2024x. Does anyone know the solution?