ChhuppaRustam
New Member
- Joined
- Apr 4, 2012
- Messages
- 6
Hi,
I have been searching for this for a long time, but no satisfactory solution.
I have a VBA based macro that filters, generates excel workbooks, saves in a specific path with designated name, protects it with designated password, send via email to designated recipients.
Its a loop - multiple files are created.
Problem: My organization has TITUS add-in added to MS Office. Each time the excel file gets saved, its asking for document classification, then again at time of sending the same file, asks for email classification. (Classification are like External Communication, Internal Communication, Confidential, Public)
Bypassing is not an option (such as switch off event) - the only way I got is to have the classification automated via VBA - it will always be "External Communication" for both document classification and email classification.
Please assist.
Regards
ChhuppaRustam
I have been searching for this for a long time, but no satisfactory solution.
I have a VBA based macro that filters, generates excel workbooks, saves in a specific path with designated name, protects it with designated password, send via email to designated recipients.
Its a loop - multiple files are created.
Problem: My organization has TITUS add-in added to MS Office. Each time the excel file gets saved, its asking for document classification, then again at time of sending the same file, asks for email classification. (Classification are like External Communication, Internal Communication, Confidential, Public)
Bypassing is not an option (such as switch off event) - the only way I got is to have the classification automated via VBA - it will always be "External Communication" for both document classification and email classification.
Please assist.
Regards
ChhuppaRustam