Link to home
Start Free TrialLog in
Avatar of COTraveler
COTravelerFlag for United States of America

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.Application' does not contain a definition for 'AutomationSecurity'.

 
Application.AutomationSecurity = Microsoft.Office.Core.MsoAutomationSecurity.msoAutomationSecurityForceDisable;

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.MSProject;


Thanks.
ASKER CERTIFIED SOLUTION
Avatar of COTraveler
COTraveler
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial