I think that TDP may have an issue with file size when opening an Excel Macro file. I’ve successfully built two reports with TDP 3.3.0.1327 using an Excel Macro file, and not had any issues, but they were both relatively small.
I’m getting the following when the Export Wizard attempts to display the macros embedded in a 18MB Excel Macro file:
System.Runtime.InteropServices.COMException
Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED))
Stack Trace:
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)
at Quest.Toad.ImportExport.Writers.WriterExcelInstance.TryCultureMethod(Type type, String method, Object target, Object[] args)
at Quest.Toad.ImportExport.Writers.WriterExcelInstance.GetMacros(String fileName)
at Quest.Toad.ImportExport.ExportWizard.wizardPageExecuteMacro_ShowFromNext(Object sender, EventArgs e)
at Quest.Toad.Controls.Wizard.WizardPage.OnShowFromNext(Wizard wiz)
at Quest.Toad.Controls.Wizard.Wizard.Next()
at Quest.Toad.Controls.Wizard.Wizard.btnNext_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
at DevExpress.XtraEditors.BaseControl.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
When I reduce the file size (by removing the default data used to construct the template), I’m able to create the Export Template using the Wizard just fine.
My concern is that when it attempts to export the large amount of data, the Export Template will choke on the file size. I’ll try it later and post the results, but it’s a 2 hour report…