I have the following code in Microsoft Office Excel, in a .xlsm
file, that’s part of a VBA Sub.
'Read a value in a Cell that is named cellName
'and stores in a variable named aVariable
aVariable = Range("cellName").Value
'Read the value from a variable named aVariable
'and stores in a Cell that is named cellName
Range("cellName").Value = aVariable
How do I rewrite this so it’s compatible to Libre Office Calc Basic (.ods
, using LibreOfficeCalc)? Is there a way to do this that is both compatible with the Microsoft Office and Libre Office?