FORMS dde.execute / trying to add worksheet to Excel

Hello all I have a Forms app that populates some data and works with MS Excel through the DDE commands. I've been searching around and am still having problems with adding a new sheet to the workbook. I have tried the following without success...ideas?????

Also, if anyone knows how macros are run from the execute command that would be helpful as well. thanks

DDE.Execute(ConvID, '[ActiveWorkbook.Sheets.Add]', 1000);
DDE.Execute(ConvID, '[ActiveWorkbook.Sheets.Add(1)]', 1000);
DDE.Execute(ConvID, '[Sheets.Add]', 1000);
DDE.Execute(ConvID, '[Sheets.Add(1)]', 1000);

Thanks,
DM Received on Thu May 01 2003 - 19:06:03 CEST