Re: generating excel files using DDE

Reply
New Contributor Vid
New Contributor
Posts: 4

Re: generating excel files using DDE

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

Super User
Posts: 19,837

Re: generating excel files using DDE

From the DDE docs:

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

Read_only_recis 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.

New Contributor Vid
New Contributor
Posts: 4

Re: generating excel files using DDE


Thanks Reeza!!  That worked.

Vidya.

Ask a Question
Discussion stats
  • 2 replies
  • 277 views
  • 1 like
  • 2 in conversation