COTraveler
asked on
How do I programmatically disable macros in Microsoft Project files using C#?
In SQL Server Integration Services (2008) I have a created a task script using C# that converts Microsoft Project (2010) MPP files to an ASCII text CSV format. The problem I have encountered is that because some of the files still have their macros enabled, the process stops and presents a window asking whether to "Enable" or "Disable" the file's macros. Because multiple files are being automatically processed, I need to set in the C# code a default of disabling all macros.
Does anybody know how to do this?
I tried the following, but couldn't get it to work because it would not recognize the "AutomationSecurity" item under Application. It returns the message: 'System.Windows.Forms.Appl ication' does not contain a definition for 'AutomationSecurity'.
Application.AutomationSecurity = Microsoft.Office.Core.MsoA utomationS ecurity.ms oAutomatio nSecurityF orceDisabl e;
Here are the references being applied at the top of the class file.
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.IO;
using Microsoft.Office.Core;
using MSProject = Microsoft.Office.Interop.M SProject;
Thanks.
Does anybody know how to do this?
I tried the following, but couldn't get it to work because it would not recognize the "AutomationSecurity" item under Application. It returns the message: 'System.Windows.Forms.Appl
Application.AutomationSecurity = Microsoft.Office.Core.MsoA
Here are the references being applied at the top of the class file.
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.IO;
using Microsoft.Office.Core;
using MSProject = Microsoft.Office.Interop.M
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.