Problem with Excel Export

Posted by: mecano on 4 August 2017, 3:09 pm EST

  • Posted 4 August 2017, 3:09 pm EST

    Hi,
    <br />
    <br />we use ActiveReports in our company and the problem is, that on some PC's the Excel export doesn't work. The following error occurs (I must translate from german ;-)
    <br />
    <br />Script-Error:
    <br />In the script on this page an error occured.
    <br />Line: 40
    <br />Character: 2
    <br />Error: The object does not support this property or method
    <br />
    <br />Things I've done yet to solve the Problem:
    <br />- Checked the versions between the PC's working and not working.
    <br />- Checked the IE-Versions
    <br />- Re-registered the dll
    <br />- Copied the dll from a working PC
    <br />
    <br />
    <br />Any ideas?
    <br />
    <br />With kind regards
    <br />
    <br />In the File attachment you'll find a hardcopy of the error (in german)
    <br />
    <br />Andreas Weber
    2008/03/Error Excel Export.JPG
  • Replied 4 August 2017, 3:09 pm EST

    <P>Hello ,</P>
    <P>It looks like the excel export dll is not registered properly.</P>
    <P>Could you please describe the system/hardware enviroment of PC?</P>
    <P>What is the build number of excel export dll?</P>
    <P>What does code line throw exception? </P>
    <P>Thanks,</P>
    <P>Sergey Romanov.</P>
  • Replied 4 August 2017, 3:09 pm EST

    I updated to the latest version of Active Reports, but still the same error.
    <br />
    <br />We all use Excel 2003 SP3
    <br />
    <br />Greetings
    <br />Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    <P>Please, try to install the latest version of Active Reports 2.0 (or just exclexpt file) on this machine.</P>
    <P><A HREF="/forums/37/ShowForum.aspx">http://www.datadynamics.com/forums/37/ShowForum.aspx</A></P>
    <P>Also, Do you use  a same version of MS Excel on all machines?</P>
    <P>Thanks,</P>
    <P>Sergey Romanov.</P>
  • Replied 4 August 2017, 3:09 pm EST

    The PC is a DELL Optiplex 755, Intel Core 2 duo processor, 2GB RAM with Win XP professional SP2, latest patches.
    <br />The version of exclexpt.dll is 2.0.0.1253
    <br />But this is the same version as on computers where everything works.
    <br />
    <br />Thank you for your help!
    <br />
    <br />Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    <P>Could you please send me or attach in forum the report.asp file packed in ZIP archive?</P>
    <P>Thanks,</P>
    <P>Sergey Romanov.</P>
  • Replied 4 August 2017, 3:09 pm EST

    Hi, thanks for your help!
    <br />
    <br />In the attachment you find the report.asp
  • Replied 4 August 2017, 3:09 pm EST

    <P>It looks like, the attachment was blocked.</P>
    <P>Could you please attach it in zip file archive?</P>
    <P>Thanks,</P>
    <P>Sergey Romanov.</P>
  • Replied 4 August 2017, 3:09 pm EST

    Done!
    <br />
    <br />A screenshot of the result messagebox is in the attachement.
    <br />
    <br />Greetings
    <br />Andreas Weber
    2008/04/Result VBS.JPG
  • Replied 4 August 2017, 3:09 pm EST

    <P>Thanks, it is a correct result :)</P>
    <P>Possibly, the problem does not relate to the export dll, we need to check the common dialog as well.</P>
    <P>Try to remove the using of "show save" dialog and set the constant file name for tests.</P>
    <P>Thanks,</P>
    <P>Sergey Romanov.</P>
  • Replied 4 August 2017, 3:09 pm EST

    <P>Hello ,</P>
    <P>Your asp file creates an instance of Excel export filter on the client machine.</P>
    <P>It requires the installed excel export dll on the client machine.</P>
    <P>Thanks,</P>
    <P>Sergey Romanov.</P>
  • Replied 4 August 2017, 3:09 pm EST

    Ugh! I'm not the programmer :-)
    <br />
    <br />Could you please edit the report.asp in the way you described and attach it to a message here, so I can exchange the file on our server.
    <br />
    <br />Thanks!
    <br />Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    As I said, the DLL is installed on the client.
    <br />
    <br />Greetings
    <br />Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    <P>Could you please create and execute a VBScript file (.vbs extension) on the client machine with following code:</P>
    <P><EM>dim xls<BR>set xls = CreateObject("ActiveReportsExcelExport.ARExportExcel")<BR>MsgBox xls.Version</EM></P>
    <P>This script should not throw any exception if excel export filter is registered correctly.</P>
    <P>Thanks,</P>
    <P>Sergey Romanov.</P>
  • Replied 4 August 2017, 3:09 pm EST

    Hi, sorry for the delay.
    <br />
    <br />I attached the report.asp in a RAR-file.
    <br />
    <br />I hope you can help!
    <br />
    <br />Greetings
    <br />Andreas Weber
    2008/04/report.rar
  • Replied 4 August 2017, 3:09 pm EST

    Hi!
    <br />
    <br />The test worked!!
    <br />The file C:\Test.xls was generated correctly.
    <br />No errors!
    <br />
    <br />This means the common dialog component is corrupt?
    <br />
    <br />What can I do?
    <br />
    <br />Thank you very much for your help!!
    <br />Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    <P>There has been a recent Microsoft update that affected many of the Microsoft 2003 Excel spreadsheets users where I work. We had to verify what systems were affected and found that the Active Report Excel files that were being created for the first time would no longer work.</P>
    <P>I did find that using a pre-existing file and writing to it did work.  </P>
    <P>Thanks for the actual fix. I hate work arounds.</P>
  • Replied 4 August 2017, 3:09 pm EST

    Hi!
    <br />
    <br />I GOT IT :-)))
    <br />
    <br />The solution was: on the PC's that don't work, the file "comdlg32.ocx" was missing!! (comdlg32.dll was there)
    <br />
    <br />Copied it from another PC and registered it, and everything works fine!
    <br />
    <br />Thank you very very much for your help!!
    <br />
    <br />Greetings
    <br />Andreas Weber
  • Replied 4 August 2017, 3:09 pm EST

    <P>Hello ,</P>
    <P>There are many reasons for why the common dialog control can not work correctly:</P>
    <P>1) Make sure that comdlg32.cab file is placed on server in folder with report.asp page.</P>
    <P>2) The loading of comdlg32 can be blocked by security settings.</P>
    <P>3) The client machine has some older/newer version of common dialog control.</P>
    <P>4) license issues.</P>
    <P>etc.</P>
    <P>Thanks,</P>
    <P>Sergey Romanov.</P>
  • Replied 4 August 2017, 3:09 pm EST

    <P>You can find report2.asp in attachment.</P>
    2008/04/report2.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels