Toad World® Forums

[TDP Beta 3.3.0.1327] [Export Wizard] Error with Excel Macro file

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…

And of course this went into the wrong forum…

Thanks for reporting it. I created a xlsm file about 24 MB with 2 macros. But I cannot reproduce the issue. Is that possible to send your Excel file to us to take a look? What OS are you using? What is your Excel version?

Thanks!

Hi Kiki,

Sure - I’ll have to strip out the actual customer data, but you can fill it with whatever junk you want to inflate it to size. I’ll have to do it tomorrow, and would prefer to email it to someone.

OS on my machine is Windows 7; OS on the automation machine is Windows XP SP3, and it’s Excel 2010.

Thanks. Please send the file to yake.li@quest.com.