topic Re: How to use DDE adding a comment to excel in SAS Procedures

How to use DDE adding a comment to excel

BETO — Thu, 03 Apr 2014 22:03:07 GMT

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 — Thu, 03 Apr 2014 22:47:02 GMT

I think it might be in NOTE command.

BETO — Fri, 04 Apr 2014 03:55:59 GMT

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 — Fri, 18 Apr 2014 04:11:04 GMT

I found what I needed using tags

Reeza — Fri, 18 Apr 2014 14:51:53 GMT

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

Also useful if someone else has the same question.