Exporting Channels with EXCELExport (VBS)

[Johannes1]

Hi,
i´m trying to export some Data to Excel, using the EXCELExport wizart.
The Code, that i´ve tryed is:

EXCELChnCount=8
EXCELChn(1)=10
EXCELChn(2)=11
EXCELChn(3)=12
EXCELChn(4)=13
EXCELChn(5)=14
EXCELChn(6)=15
EXCELChn(7)=16
EXCELChn(8)=17
call EXCELExport (T10,"",0,"")

The Excel-File ist created and open. The code runs without any error, but there is no Data in the Excel-File.
Whats wrong?

[Ken_Tobler]

Hi!

Create a STP file with the configuration of the Excel Export.
In the configuration you should check which channel you want to export. Once you created the STP file, you can call

call EXCELExport (T10,"",0,"MyConfiguration.stp")

and the data should be inside the file excel.

At best set the EXCELDlgFlag to 1 and create a STP file (by checking the "SAVE" checkbox by the configuration file).
Then you can set the EXCELDlgFlag to 0 and use this configuration file for saving your excel file.

Best regards

Ken

[Johannes1]

Thanks,
but it dont work realy. When I set the Dialog Flag to 0, there ist no file createt. When I set it to 1 and directly push "finish" ist works. I don´t know why. I´ve checked both, the place for the  *.stp and for the created file. Is there any other variable to set?

[Ken_Tobler]

The best is to set the Dialog Flag 1 only once and create the STP file: f.e. C:\MyConfiguration.stp
Once you have the STP file, you return the Dialog Flag to 0 and in the function ExcelExport you give the path of the STP file: f.e.

call ExcelExport("C:\MyFile.xls", "",0,"C:\MyConfiguration.stp")

So you will use your "MyConfiguration.stp" every time you make an export to excel without having to pop up the dialog.

Regards

Ken