How To Fix RSR_EXCEL_RUNTIME102 - Access to Visual Basic project denied

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 102

• Message text: Access to Visual Basic project denied

What causes this issue?

The BEx Analyzer cannot generate VBA code due to the security settings.

System Response

VBA code is not generated.

How to fix this error?

Choose <ZK>Tools</> -> <ZK>Macro</> -> <ZK>Security</>.
On the <ZK>Trusted Publishers</> tab page, select <ZK>Trust access to
Visual Basic project</>.
Choose OK.
Close the BEx Analyzer and continue working as before.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Access to Visual Basic project is only needed when generating VBA code.
This only takes place in design mode or when 3.x workbooks are upgraded.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSR_EXCEL_RUNTIME102 - Access to Visual Basic project denied ?

  The SAP error message RSR_EXCEL_RUNTIME102: Access to Visual Basic project denied typically occurs when you are trying to export data from SAP BW (Business Warehouse) to Excel, and there is an issue with the Excel settings or the security settings of the Visual Basic for Applications (VBA) environment.
  Cause:
  
  
  Excel Security Settings: The error often arises due to the security settings in Excel that prevent access to the Visual Basic project. This can happen if the macro settings are set to "Disable all macros without notification" or if the workbook is opened in a mode that restricts access to the VBA project.
  
  
  Protected Workbook: If the Excel workbook is protected or if the VBA project is locked with a password, you will not be able to access it.
  
  
  Excel Version Compatibility: Sometimes, compatibility issues between different versions of Excel and SAP can lead to this error.
  
  
  Solution:
  To resolve the RSR_EXCEL_RUNTIME102 error, you can try the following steps:
  
  
  Change Macro Security Settings:
  
  Open Excel.
  Go to File > Options > Trust Center > Trust Center Settings.
  Click on Macro Settings.
  Select Enable all macros (not recommended for security reasons) or Disable all macros with notification.
  Ensure that the option Trust access to the VBA project object model is checked.
  
  
  
  Check Workbook Protection:
  
  Ensure that the workbook you are trying to export to is not protected. If it is, you will need to unprotect it.
  
  
  
  Check for Locked VBA Project:
  
  If the VBA project is locked, you will need to unlock it. This typically requires the password used to lock the project.
  
  
  
  Use a Different Excel Version:
  
  If you are using an older version of Excel, consider upgrading to a newer version that is compatible with your SAP BW version.
  
  
  
  Reinstall or Repair Excel:
  
  If the problem persists, consider repairing or reinstalling Microsoft Excel to ensure that all components are functioning correctly.
  
  
  
  Check SAP Notes:
  
  Sometimes, specific SAP Notes may address known issues with certain versions of SAP BW and Excel. Check the SAP Support Portal for any relevant notes.
  
  
  
  Related Information:
  
  SAP BW and Excel Integration: SAP BW allows users to export data to Excel for reporting and analysis. Understanding the integration between SAP and Excel is crucial for troubleshooting issues.
  VBA Security: Familiarize yourself with VBA security settings in Excel, as they can impact the ability to run macros and access VBA projects.
  SAP Community: The SAP Community forums can be a valuable resource for finding solutions to specific error messages and issues encountered by other users.
  
  By following these steps, you should be able to resolve the RSR_EXCEL_RUNTIME102 error and successfully export data from SAP BW to Excel.