I'm using the old DsoFramer control to embedded an instance of Excel in a form of mine. This has been working fine with Excel 2000, 2003 and 2007.
Come 2010 however I think its behaving slightly differently. I now get a prompt about macros, which then blocks my UI until the user shifts focus to the excel instance in the background and clicks ok.
I know that Microsoft don't endorse using this control anymore, but unfortunately we're not in a position to replace it yet. So what I'm looking for our ways to try and disable this dialog. I've tried using the MsoAutomationSecurity.msoAutomationSecurityForceDisable enum but this doesn't seem to make any difference. If I open the file directly through code then its fine and doesn't prompt, but the axFramer.Open() call always causes it to prompt. Does anyone know of a way round this?
Code to reproduce this issue in a simple WinForm app (you'll need to substitute the file path to a file containing macros).
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using Microsoft.Office.Interop.Excel;
using System.Diagnostics;
namespace WindowsFormsApplication1
{
public partial class Form1 : System.Windows.Forms.Form
{
private AxDSOFramer.AxFramerControl axFramer;
public Form1()
{
// Kill any Excel processes first so they don't interfere with our tests
KillExcelProcesses();
InitializeComponent();
try
{
CreateAndAddFramer();
string file = @"c:\temp\date_6490.xls";
// Create a new Excel Application. For the purpose of the test lets ensure it's visible too.
Application excelApp = new Application() { Visible = true, DisplayAlerts = false };
// Set the Excel security to Forcefully disable all macros.
excelApp.AutomationSecurity = Microsoft.Office.Core.MsoAutomationSecurity.msoAutomationSecurityForceDisable;
// Open the file. This is because it needs to be open before trying with the DsoFramer
// control. It also demonstrates that excel opens fine without prompting for any
// macro support.
Workbook selectedBook = excelApp.Workbooks.Open(file);
// Open the file in the framer. This will now prompt to enable macros.
axFramer.Open(file, true, null, null, null);
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.ToString());
KillExcelProcesses();
}
}
/// <summary>
/// Creates a DsoFramer and adds to the form.
/// </summary>
private void CreateAndAddFramer()
{
// Create an axFramer control
this.axFramer = new AxDSOFramer.AxFramerControl();
// Initialize the axFamer
((System.ComponentModel.ISupportInitialize)(this.axFramer)).BeginInit();
// Update the name of the framer (bug in framer)
this.axFramer.Name = "framer_" + Guid.NewGuid().ToString();
this.axFramer.ResetText();
// Dock the framer and add to the form
this.axFramer.Dock = System.Windows.Forms.DockStyle.Fill;
this.Controls.Add(axFramer);
((System.ComponentModel.ISupportInitialize)(this.axFramer)).EndInit();
}
/// <summary>
/// Kills all excel processes.
/// </summary>
private static void KillExcelProcesses()
{
// Kill all instances of Excel
foreach (Process p in Process.GetProcessesByName("excel"))
{
p.Kill();
}
}
}
}