Originally Posted by st_albert
FWIW, I tried it in LibreOffice v. 22.214.171.124, but it fails with an error
"BASIC syntax error. Symbol expected" at this code (among several):
Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1
Type file <=== error at this line
name As String
size As Long
and as far as I can tell, the syntax is right. Needless to say, I'm not much of an OO Basic or VBA programmer.
You can be sure that the syntax is right - from the point of view of Excel.
Maybe LO doesn't support user defined types.
But the more probale reason is that it collides with the reserved names of LO. Replace "file" with "datei" (or "ficher"
) in the "Type" and in the "Dim" - declaration and see if it works.