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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Data Collection
Survey Reporter Desktop

Software version:

6.0.1

Reference #:

PM84803

Modified date:

2013-11-26

Translate my page

Machine Translation

Content navigation