Ask Your Question

kokbira's profile - activity

2016-10-28 20:58:48 +0200 received badge  Notable Question (source)
2016-10-28 20:58:48 +0200 received badge  Popular Question (source)
2016-10-28 20:58:48 +0200 received badge  Famous Question (source)
2016-03-18 13:42:20 +0200 received badge  Editor (source)
2016-03-18 13:41:11 +0200 asked a question How to use VBS to manage Calc files?

I am learning VBS scripts and someone gave me a code below, that works with Microsoft Excel. How to convert it to works 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"
2016-03-18 13:27:21 +0200 commented question Conversion of Excel VBScript to Calc Script Language

Any news??