المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : How do I programmatically disable macros in Microsoft Project files using C#?



C# Programming
08-24-2012, 12:52 AM
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.

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.
The science of business is the science of service, to this end it is better to do more than you promise than to promise more than you do.