I’m working on a series of macros that are embedded in a LibreOffice Calc spreadsheet for personal use. Some of those macros are supposed to load one of two dialogs that are embedded in the same spreadsheet.
The code for the two macros in question:
' Purchase Dialog Sub DiagPurchase pd = Tools.ModuleControls.LoadDialog("Standard", "PurchaseAmount") pd.Execute() End Sub ' Deposit Dialog Sub DiagDeposit dd = Tools.ModuleControls.LoadDialog("Standard", "DepositAmount") dd.Execute() End Sub
When I run them, they’re supposed to open those dialogs.
What actually happens is they throw “BASIC runtime error.
An exception occurred
Message: .” and highlight
oLibDialog = oLib.GetByName(DialogName)
in the ModualControls thing in the Tools library.
How do I fix this?