I am learning VBS scripts and someone gave me a code below, that works with Microsoft Excel. How to convert it to work with LibreOffice Calc?
Dim ObjExcel
Call ExcelSetup("Sheet1")
Sub ExcelSetup(sheetName)
Set objExcel = CreateObject("Excel.Application")
Set objwb = objExcel.Workbooks.Add
Set objwb = objExcel.ActiveWorkbook.Worksheets(sheetName)
Objwb.Name = "Sheet name for user"
objwb.Activate
objExcel.Visible = True
objwb.Cells(1, 2).Value = "Hello world!"
End Sub
MsgBox "The End"
Best Answer
Here is a script, adapted from https://www.openoffice.org/udk/common/man/tutorial/office_automation.html: