Visual Basic Script to excell

[mike347]

Tia Portal v15.1

How can I put the date and time in an Excel file with a Visual Basic script?
Can you help me??

Greetings

[Rex2701]

stackoverflow.com helps you:

Code: Select all

Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("Your_Excel_File.xls")
objExcel.cells(1,1).value = "Test value"
objWorkbook.Save
objWorkbook.Close

But it is a pure VBS example. I have no idea does TIA supports the "CreateObject" directive or not.