open Excel using DDE in DIAdem

[wilburwu]

Hi everyone,

I found that in DIAdem Sript we may use the DDEOpen command to open Excel table. 

As I try to run the example sript in DIAdem help. It requires to open the excel.exe before it uses the DDE interface.

Is there a way to call Excel from script.

And I always have some DDE error, to say the DDE server doesn't react to the DDEOpen command, even if I've open an excel sheet.

Any suggestions? 

[Otmar]

Hello wilburwu

I am far from being a programmer, but this seems to work to open an empty Excel workbook from DIAdem:

Dim Excel                     'Excel object variable
Set Excel = CreateObject("Excel.Application")
Excel.Visible = True ' Starts Excel 
Excel.Workbooks.Add  ' Creates a new Excel document

Maybe this will get you on the right path ...

     Otmar