Could you please to help me to write the VBscript to create csv file for HMI TP1200 Comfort?

.csv file should be located on SD card.

I just need a simple code to locate the csv on in the HMI SD

Thank you in advance

------------------------------------------------------------------------------------------
Split from how to create excel file.

Hi Siemens_Repair_Man,

I think that you can create excel directly by VBscript

Be aware of your TP1200 OS: I think it is Win CE. There will be other functions (or syntax) for File-Object as in Windows 7.

Please look at: http://www.cerrotorre.de/faq-script/faq-script-excel.htm

Regards

I wrote this code:

     Dim    objExcel

     Dim    File

     Dim objWorkbook

    Dim FilePath

    FilePath="\Storage card SD\test.xlsx"

    Set File = Createobject("Scripting.filesystemobject")

   Set objExcel=CreateObject("Excel.Application")

   Set objWorkbook=objExcel.workbooks.add

   if File.FileExists(FilePath) = true then

   else

      objExcel.activeworkbook.saveas FilaePath

  End If

      objExcel.activeworkbook.close

     objexcel.quit

Set File= Nothing

Set objExcel=Nothing

           But unfortunately I did not see any excel file on SD card in HMI TP1200 Comfort windows CE version  6.0.

What did I do wrong?

With Comfort panel, one cannot create Excel files.

Also your script assumes that you have Excel installed on your WinCe device. 

Also you are using wrong object, with WinCe you do not ha scripting.filesystemobject

You can write csv-file like below.

Dim fs

Set fs = CreateObject("FileCtl.File")

fs.Open "\Storage Card SD\someFile.csv", 2 ' 2 for write/overwrite 8 for append

fs.LinePrint "my, csv, file"

Only separate your columns with ,

CSV is just a text file and it is not a Excel file.