PM38514: MACRO I_PROCESS SHOWS RUNTIME ERROR 1004 IN TM1 9.5 WITH EXCEL 2007

APAR status

• Closed as program error.

Error description

• In TM1 9.5 with Excel 2007 the Macro I_PROCESS does not run
  successfully and shows Runtime Error 1004 ??????repro steps: ??-
  create a csv file in C:\Temp\Hans.csv (for example add some
  letters in 1st Row in columns A, B and C) ??- open a new Excel
  spreadsheet ??- pressing Alt + F11 to open the VBA environment
  and copy the code below to VBAProject (Book1), then execute step
  by step with F8 ??????Public Sub Test () ??Dim sNewfilenameKPS
  as Variant ??sNewfilenameKPS = "C:\Temp\Hans.csv" ??Run
  I_PROCESS "sNewfilenameKPS ??End Sub ??????test result: ??1)
  Test with 9.5.1 and Excel 2003 -> everything works fine ????2)
  Test with 9.5.1 and Excel 2007 -> when the macro I_PROCESS is
  called, "Runtime Error 1004 Application-defined or
  object-defined error" occurs ????????Note: ??macros in Excel
  2007 were anabled and defined as trusted. ??Test with new
  version TM1 9.5.2 and Excel 2007 shows the same error. ??Also
  the Macro I_NAMES has the same faulty behavior with 9.5.2 and
  Excel 2007 (according to customer all macros with name I_* have
  this problem)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos TM1 9.5.1 FP1 or Upgrade to IBM Cognos *
  * TM1 9.5.2 FP1 or Upgrade to IBM Cognos TM1 10.1.0            *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• 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

  TM1 PERSPECTIVE

• Fixed component ID

  5724W49PE

Applicable component levels

• R951 PSN

     UP