6/8/2016 9:11 AM | |
Posts: 2 Rating: (0) |
Dear all, I've Problem regarding logging the tag in excel sheet in proper format. I have used the following script in TIA wincc advance v13 which worked over there but same script is not running in wincc 7.3 no excel sheet is opening here and, secondly, . I have also tried to exort data from wincc online trend control where I only get CSV format and I opened it in excel and I got the excel in improper format(I have attached excel improper format). please help me with this 2 problem. Sub VBFunction_2() 'Please replace all sequences which are enclosed with '_' by your own code. DY=Day(Date()) D=DY & "/" & MNTH & "/" & YR 'take or modify a tag value here
Set objExcel=CreateObject("Excel.Application") If Not fso.FileExists(strExcelPath) Then
Row_Cnt = objSheet.UsedRange.Rows.Count objSheet.Cells(Row_Cnt+1,1).Value = D objExcel.ActiveWorkbook.Save 'Tip:
Attachmentexcel improper format.docx (72 Downloads) |
Follow us on