setting security information classification of microsoft office files

[Manny3]

Hi All,

we are working on a requirement to generate an excel file in batch mode  and then set the security information classification for that excel file .

Although first part is quite an easy task but I am not getting any way out to handle the second stuff i.e. to set the security of information classification via SAS code . WIth classification I mean the internal classification available in Microsoft office , like confidential, internal etc.

If any one have an idea about it please share. it will be a great help. 

Regards,
Manny

[FreelanceReinh]

Hi @Manny3,

How would you set that classification without SAS? I'm not sure, is this one of the document properties (like title, author, subject, etc.)? If so (and possibly even if not), this information can be modified using VBA. Of course, SAS can generate VBA code dynamically (i.e. a text file with .bas extension). And there are ways to execute this VBA code as well: A couple of years ago, I used techniques similar to those described in this SUGI paper (macro run_vba.sas etc.) to let SAS handle Word documents. A quick internet search ("Visual Basic" "Excel" "SAS") suggests that other people have done similar things with Excel.

[Manny3]

Hi @FreelanceReinh,

Thanks for the revert and sorry for that typo error.

I tried few things as suggested, but I feel Microsoft don't allow to modify the information security classification via Macros.
Even I tried to cross check it by recording a macro in excel and updating the security classification, but didn't got anything in macro body .

Please share some ideas on this , if you have done something like this in past.

Regards,

Manny

[FreelanceReinh]

I see. So, it seems to be even more difficult than I had imagined.

What I did in that project back then had nothing to do with security information classification. It was more like page formatting etc.

Maybe you can get some information from an Excel forum and then come back for the SAS specific part. I'm sorry I cannot be more helpful.

Good luck!

[FreelanceReinh]

I've just remembered a presentation (on a SAS conference) where someone reported about automating processes involving PowerPoint. They used AutoIt and (I think) managed to operate PowerPoint from SAS via AutoIt.

Obviously, whatever can be done using keyboard and mouse can (in principle) be automated with such tools. So, this might be a last resort if everything else fails.

[Manny3]

Thanks @FreelanceReinh,

I have not used Autoit  yet, so it will take me some time to dig it .. but have something to  check for. 

Thanks a lot . 🙂