Error no 1004: The macro ’cc.SetForegroundEx’ cannot be found

If you receive the error message Error no 1004: The macro ’cc.SetForegroundEx’ cannot be found when trying to preview a report from Microsoft Excel, the Controller add-in may not have been loaded properly.

To correct this problem, follow the steps below:

Procedure

  1. Close all Excel sessions.
  2. From the Task Manager, find the Excel.exe process.
  3. End this process.
  4. Re-run the IBM® Controller report from Excel.