Mac – MS Excel Vba/Macro equivalent in LibreCalc or OpenOfficeCalc

libreofficemacrosmicrosoft excelvba

is there an equivalent macro/vba in libre calc that does this routine;
– Read/open xls files in a path and do a batch import/copy of read sheets and merge it with the current open workbook.
Here's the vba I used in MS Excel. Thanks in advance

Sub Consolidate_Sheets()
'Folder Path to read the xlsx files from

  Path = "F:\WIP2\Below 25\"
  filename = Dir(Path & "*.xlsx")

  Do While filename <> ""
    Workbooks.Open filename:=Path & filename, ReadOnly:=True

    For Each sheet In ActiveWorkbook.Sheets     
     'import/copy sheets from to read xlsx files
      sheet.Copy After:=ThisWorkbook.Sheets(1)    
    Next sheet

    Workbooks(filename).Close
    filename = Dir()
  Loop

End Sub

Best Answer

OpenOffice/LibreOffice has a VBA-like macro system which is designed to have a good degree of compatibility with VBA.

You can get to it by Tools->Macros->Organize Macros->(Libre/Open)Office Basic... If you then click "Edit" you get an editor that is very similar to the VBA IDE.

It's fairly likely that your macro will work with minimal modifications. (Your code seems to run without errors for me, but I obviously don't have your input files.)

Related Question