[Libreoffice-bugs] [Bug 118241] FILEOPEN XLSX Basic code with CreateObject("Scripting.FileSystemObject") and “For Each ” loop does not work
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sun Jun 24 22:49:02 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=118241
--- Comment #3 from himajin100000 at gmail.com ---
Created attachment 143078
--> https://bugs.documentfoundation.org/attachment.cgi?id=143078&action=edit
reproducible document with simpler code
DON' FORGET TO PUT SOME FILES in C:\lolog
I had 12 files there
Expected Result(in Excel VBA):
True
Actual Result(in LibreOffice StarBasic):
False
Minor note:
It seems StarBasic Adds "Option VBASupport 1", when it opens .xlsm . This
option is required to get Actual Result. if you don't have this line, you will
encounter a "type mismatch error". Even in this case you will not get the
Expected Result.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180624/c26de976/attachment-0001.html>
More information about the Libreoffice-bugs
mailing list