View Single Post
Old 06-10-2012, 04:52 AM   #35
mmat1
Det
mmat1 ought to be getting tired of karma fortunes by now.mmat1 ought to be getting tired of karma fortunes by now.mmat1 ought to be getting tired of karma fortunes by now.mmat1 ought to be getting tired of karma fortunes by now.mmat1 ought to be getting tired of karma fortunes by now.mmat1 ought to be getting tired of karma fortunes by now.mmat1 ought to be getting tired of karma fortunes by now.mmat1 ought to be getting tired of karma fortunes by now.mmat1 ought to be getting tired of karma fortunes by now.mmat1 ought to be getting tired of karma fortunes by now.mmat1 ought to be getting tired of karma fortunes by now.
 
mmat1's Avatar
 
Posts: 982
Karma: 1406156
Join Date: Jan 2012
Location: Zischebattem
Device: Acer Lumiread
Quote:
Originally Posted by st_albert View Post
FWIW, I tried it in LibreOffice v. 3.5.3.2, but it fails with an error

"BASIC syntax error. Symbol expected" at this code (among several):
Code:
Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1
Option Explicit
 Type file       <=== error at this line
  name As String
  size As Long
 End Type
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.
mmat1 is offline   Reply With Quote