04-10-2014 01:35 PM
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?
04-10-2014 01:41 PM
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.