topic Re: generating excel files using DDE in SAS Programming

Re: generating excel files using DDE

Vid — Thu, 10 Apr 2014 17:35:04 GMT

Hi,

Is there a way to create Read Only Access excel files using DDE technique? I am creating excel files in sas using excel xp tagsets and converting them to native excel using DDE but do not want anybody to make any changes in it by mistake?

Thanks

Vidya

Re: generating excel files using DDE

Reeza — Thu, 10 Apr 2014 17:41:36 GMT

From the DDE docs:

SAVE.AS(document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec)

Read_only_rec

is a logical value corresponding to the Read-Only Recommended check box in the Save Options dialog box.

If read_only_rec is TRUE, Microsoft Excel saves the workbook as a read-only recommended workbook; if FALSE, Microsoft Excel saves the workbook normally; if omitted, Microsoft Excel uses the current settings.

When you open a workbook that was saved as read-only recommended, Microsoft Excel displays a message recommending that you open the workbook as read-only.

Re: generating excel files using DDE

Vid — Mon, 21 Apr 2014 17:52:46 GMT

Thanks Reeza!! That worked.

Vidya.