Help using Base SAS procedures

How to use DDE adding a comment to excel

Reply
Regular Contributor
Posts: 240

How to use DDE adding a comment to excel

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

Super User
Posts: 19,789

Re: How to use DDE adding a comment to excel

I think it might be in NOTE command.

Regular Contributor
Posts: 240

Re: How to use DDE adding a comment to excel

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;


Regular Contributor
Posts: 240

Re: How to use DDE adding a comment to excel

I found what I needed using tags

Super User
Posts: 19,789

Re: How to use DDE adding a comment to excel

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

Also useful if someone else has the same question.

Ask a Question
Discussion stats
  • 4 replies
  • 1672 views
  • 3 likes
  • 2 in conversation