How to use DDE adding a comment to excel

[BETO]

HI,

what I'm trying to do is export a table to excel with a couple of excel comment boxes in row1  ... I need to auto insert a comment box into the file..

thanks for your assistance

[Reeza]

I think it might be in NOTE command.

[BETO]

HI Reeza,

i have this but for some reason it's not  finding the file

data _null_;

set class;

file ddedata;

put Name '09'x Sex '09'x Age '09'x Height '09'x Weight; 

run;

   data test1;

length name $10 sex $1;

input name & sex age height weight;

cards;

Alfred M 14 69.0 112.5

Mary Anne F 12 66.5 94.0

run;

/* WRITE BODY */

filename ddedata dde"excel|[C:\Users\U770846\Desktop\GC.xls]||sheet1!r3c1:r4c5";

data _null_;

set test1;

file ddedata;

put name sex age height weight;

put 'objWorksheet.Cells(1, 1).AddComment "Test comment."';

run;

[BETO]

I found what I needed using tags

[Reeza]

Can you post it back to the thread, I'm curious.

Also useful if someone else has the same question.