HD82124: MACRO RESULTS ARE DIFFERENT BETWEEN CATIA AND EXCEL

APAR status

• Closed as Permanent restriction.

Error description

• Problem:
  Macro results are different between CATIA macro
  and Excel Macro.
  Scenario:
  1. Launch the CATIA.
  2. Open the attached Assy.CATProduct.
  .
  A. Standard Macro:
  3. Go to Tools > Macro > macros.
  4. Select the attached VBAProject1.catvba.
  5. Run the macro.
  .
  Actual Result:
  Instance name of Part "aaa" is changed. Link
  of "bbb\External References\Line.1" is not broken.
  .
  B. Excel macro:
  6. Close the CATProduct without saving and reopen
  it.
  7. Open the attached Book1.xls.
  8. Click on "CommandButton1" to run the macro.
  .
  Actual Result:
  Instance name of Part "aaa" is changed. But the
  link of  "bbb\External References\Line.1" is
  broken.
  .
  

Local fix

Problem summary

• Macro results are different between CATIA and Excel
  Problem:
  Macro results are different between CATIA macro
  and Excel Macro.
  Scenario:
  1. Launch the CATIA.
  2. Open the attached Assy.CATProduct.
  .
  A. Standard Macro:
  3. Go to Tools > Macro > macros.
  4. Select the attached VBAProject1.catvba.
  5. Run the macro.
  .
  Actual Result:
  Instance name of Part "aaa" is changed. Link
  of "bbb\External References\Line.1" is not broken.
  .
  B. Excel macro:
  6. Close the CATProduct without saving and reopen
  it.
  7. Open the attached Book1.xls.
  8. Click on "CommandButton1" to run the macro.
  .
  Actual Result:
  Instance name of Part "aaa" is changed. But the
  link of  "bbb\External References\Line.1" is
  broken.
  .
  

Problem conclusion

• THIS PROBLEM IS PERMANENT RESTRICTION IN
  CATIA.
  .
  Incident Diagnosis:
  Macro results are different between CATIA and
  Excel
  .
  Restriction Explanation:
  External Macros like macro from Excel file does not
  allow to reroute pointing objects and reconnection
  of elements.
  Rerouting of pointed objects can be maintained via
  only internal macros i.e from macros in CATIA only
  which can maintain the instance reference link.
  .
  By-Pass:
  Instance reference link can be maintained via
  CATIA macro only.
  .
  

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

Applicable component levels