Hey, thank you for LibreOffice and your time.
I use a scientific extension on LibreOffice 7.3 (for Excel and Python, but installed with a wrapper for LibreOffice)
Formulas work fine in cell.
I try to use this same formula in BASIC (according to editor snippets) and I have the error
BASIC runtime error
Sub-procedure or function procedure ar not defined
Additional information: PropSI
‘PropSI’ is the formula which works fine in formula
Ma question is,
Do I do a special action for making an extension, which works in formula, works in BASIC macros ?
The extension is Coolprop (http://coolprop.org)
Option VBASupport 1 REM ***** BASIC ***** ' Ne fonctionne pas, erreur 35 ; Not defined 'Changer les guillements Sub Test1_1() 'density of Nitrogen at 101325 Pa & 300 K ' Dim D1 as Variant D1 =PropsSI("D", "P", 101325, "T", 300, "Nitrogen") Print D1 & " kg/m^3" '1.13816468646245 kg/m^3 'order of input properties is irrelevant D2 = PropsSI("D", "T", 300, "P", 101325, "Nitrogen") Debug.Print D2 & " kg/m^3" '1.13816468646245 kg/m^3 End Sub
Thank you for your time :).
José from France.