"Runtime error 91: Object variable or With block variable not set" when exporting a report to Microsoft Excel
Entry Type: Informational
Product: FRx
Application: FRx Desktop
Version Reported: 6.081
Subject:
The error "Runtime error 91: Object variable or With block variable not set" occurs when exporting a report to Microsoft Excel.
Possible Resolution:
- The Catalog ID is damaged. To resolve, create a new Catalog ID:
- Create a new catalog ID for the report. Select the same row, column, reporting tree (if applicable), and detail level, and save.
- Generate the report using the 'Enhanced XML' Drilldown Viewer.
- After the report launches in the Drilldown Viewer, select File / Export / Worksheet File / Excel (.XLS).
- Microsoft Excel is not properly registered with Microsoft. For assistance with this matter, please contact Microsoft.