generating excel files using DDE

[Vid]

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

[Reeza]

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.

[Vid]

Thanks Reeza!!  That worked.

Vidya.