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
‘35’
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)
Code Example…
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.