How can i transfer filtered data from diadem to excel?

[etoumann]

Hi,

i'm trying to write a script which would allows me to transfer data automatically from diadem to excel and i need some help.

i want to copy the last of my selected channels, open an excel file and paste data into it.

My script look like this

...
Dim ExcelTable
...

Call DATABLCLPCOPY("1,137,139,142-168,172-225,227,229,231,233,235,237,239,241,243",j,1) '... CHNNOSTR,CHNROW,VALNO

Set ExcelTable=GetObject("K:\...\Anl_kal_v3_2006.xls!SN1")
ExcelTable.Application.Visible = True

One problem is that i don't know how to continue and the other is that this script only get the programm MS-Excel started and don't open my file.

I hope i explained it the way you could understand and so you could give me ur help.

Thanks

[Walter_Rick]

Hi Patrick,

In DIAdem we provide an example which shows the things you would like to do. The script name is "Expl_OLE.vbs". You find it in the folder ..\Libr\Aut\.

I hope this will help you.

Greetings
Walter