Export in Automation Setup

Toad Data Point & Toad Intelligence Central
1

I’m getting the error below when I try to set up an export to an Excel file. It pops up when the part of the wizard shows the form to run macros. I changed the security in Excel without any luck. Any advice?

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.ImportExport.Writers.WriterExcelInstance.LoadVBAssemblies(Assembly& vbePIA, Version excelVersion)
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 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)

2

What version of Excel are you using? Was the issue reproducible when you use export wizard without automation?

3

Excel version is 2007 on WinXP
I’ve never made it through the wizard as the error pops up with the output I gave in the first post. Then the input form that is supposed to have a list of the macros shows up but there aren’t any macros populated in either PRE or POST areas.

Thanks for the reply.

4

Thanks for the information. You probably don’t have Excel PIA installed on your system. Please try

  1. Download it from
    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=18346
  2. Install it
  3. Reboot your system and try again.

Let me know if it resovles your issue.

Thanks!

5

That did it! Thanks.