Need some help with DDE script function

[Pat_Rick]

Hi everyone!!

Could someone show me how to use the DDE script function to call a DTS package(SQL server). Or to call an excel spread sheet.

Can it be done!!

Thanx in advance for your input and help.

Pat.

[fm7user]

If you just want to open excel then use Open URL ("pathnamefilename").

If you want to call DTS then write your DTS script in a batch file, then have Open URL call it. Your batch file may look like this:

"C:Program FilesMicrosoft SQL Server80ToolsBinndtsrun.exe" /N<MYDTS>

If you want to call an excel function using DDE Excecute:

Service Name: Text, Excel

Topic: Text, System

Commands: Text, [run("myexcel.xls!mymodule.myfunction")]

**oops this is in version 55/6 but it should work with 7.