Help using Base SAS procedures

Execute excel macro's through SAS program

Reply
Occasional Contributor
Posts: 12

Execute excel macro's through SAS program

Dear All Friends,

I am new user. I have lot of interest in SAS programming.

Execute excel macro's through SAS program.

Does anyone have any ideas?

Please guide me.

Best Regards,

Pankaj

Super User
Posts: 5,426

Execute excel macro's through SAS program

Posted in reply to Pankaj_23

You might some more help if you this in the http://communities.sas.com/community/integration_with_microsoft_office forum. You also need to describe more how your application should work.

One idea is to use DDE, even though Microsoft doesn't favor (support?) this technique any more.

/Linus

Data never sleeps
SAS Super FREQ
Posts: 8,864

Execute excel macro's through SAS program

Posted in reply to Pankaj_23

Hi,

If you search on support.sas.com for examples of using the ODS TAGSETS.MSOFFICE2K_X destination, I believe it has a way to pass an Excel macro name from SAS/ODS to Excel. You use the ODS TAGSETS.MSOFFICE2K_X destination to create an HTML file from your procedure output ... and it is this HTML file that Excel knows how to open into worksheet form.

Cynthia

Ask a Question
Discussion stats
  • 2 replies
  • 137 views
  • 0 likes
  • 3 in conversation