What can I do with a recurring error that reads “BASIC runtime error. ‘423’ AutoCorrect”. This is preventing me from opening worksheets with macros in LibreOffice 6.3.6x64
This is the file giving me issues currently:
BASIC error 423 is Property or Method unknown, likely something trying to call a function or access a property AutoCorrect that doesn’t exist in that context.
Update 2020-05-01T21:24+02:00
So… that is quite some Excel-VBA macro collection… the failure in this case probably is one of
Private Sub Workbook_Activate()
Application.AutoCorrect.ReplaceText = False
End Sub
Private Sub Workbook_Deactivate()
Application.AutoCorrect.ReplaceText = True
End Sub
However, there’s other heavy use of Excel related accesses, of which likely not all are implemented in the VBA compatibility layer of StarBASIC. You’ll have to rewrite at least portions for the LibreOffice document model and API.
How do I resolve this problem so I can work with worksheets that have macros. One is very critical as its a tax return file…these files used to work okay with MS-Office…
We don’t know your macros so can’t say. If you are willing to attach a (redacted) document to your question that contains the macro maybe someone could.
Done. I have uploaded a file…
thanks for explaining it. I am not the author but only a cosumer of the file as its used in filing tax returns. I guess its built on premise that one will use MS-Office which I had moved from because it was constantly asking me to reactivate license…my goose is cooked.