IBM Support What's New?

PM84803: EXPORT TO EXCEL FAILING WITH VBA MACRO ERROR : FAILED TO LOAD TABLE XML : UNSPECIFIED ERROR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • You are getting below error message when exporting tables to
    Excel :
    VBA Macro Error :
    Error Number: -2147221504
    Description: CRenderTable.Render: Failed to load table XML:
    Unspecified error
    Source: CRenderTable.Render
    
    After clicking OK on above error, following Export error message
    is shown :
    
    -----------------------------------------
    [Error] Export error.
    -----------------------------------------
    VBA Macro Error:
    Error Number: -2147221504
    Description: CRenderTable.Render: Failed to load table XML:
    Unspecified error
    
    Source: CRenderTable.Render
    -----------------------------------------
    [Error] VBA Macro Error:
    Error Number: -2147221504
    Description: CRenderTable.Render: Failed to load table XML:
    Unspecified error
    
    Source: CRenderTable.Render
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Data Collection 6.0.1 & 7.0                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * EXPORT TO EXCEL FAILING WITH VBA MACRO ERROR : FAILED TO     *
    * LOAD                                                         *
    * TABLE XML : UNSPECIFIED ERROR                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This issue has been addressed in Data Collection 7.0 Fix     *
    * Pack 1.                                                      *
    ****************************************************************
    

Problem conclusion

  • This issue has been addressed in Data Collection 7.0 Fix Pack 1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM84803

  • Reported component name

    SPSS SURVEY RPT

  • Reported component ID

    5725A78RD

  • Reported release

    601

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-03-14

  • Closed date

    2013-11-26

  • Last modified date

    2013-11-26

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    SPSS SURVEY RPT

  • Fixed component ID

    5725A78RD

Applicable component levels

  • R601 PSN

       UP

  • R601 PSY

       UP

  • R700 PSN

       UP

  • R700 PSY

       UP



Document information

More support for: SPSS Data Collection
Survey Reporter Desktop

Software version: 6.0.1

Reference #: PM84803

Modified date: 2013-11-26