15 Replies Latest reply: Feb 1, 2013 8:26 AM by Jerry Svensson RSS

    ActiveX component can't create object: 'Excel.Application' error on IE

    Kokpeng Low

      Hi All,

      I have a macro which has the following line:

      set XlApp = CreateObject("Excel.Application")

      The macro works fine when I tested on my local QV 32 bit. I'm able to copy and paste the object I wanted to Excel after clicking the button

       

      However, when I deploy this to the server which uses 64 bit QV, I'm getting the following error when I access the report through AccessPoint:

      Macro parse failed. Functionality was lost.

      SendToXL_8_1_1

      Error: ActiveX component can't create object: 'Excel.Application'

       

      Please help... Is it because the QV in the server is 64 bit? Is this possible?