Error Summary

Error while opening downloaded excel file to upload GL Journals

Error Description

COMException: Programmatic access to Visual Basic Project is not trusted

Source: Microsoft Excel

Stack: 

   at Microsoft.Office.Interop.Excel._Application.get_VBE()

   at oracle.adf.client.windows.excel.om.api.ExcelApplication.EnsureVBAInitialized()

   at oracle.adf.client.windows.excel.om.api.ExcelWorksheet.get_VstoWorksheet()

   at oracle.adf.client.windows.excel.om.api.ExcelButtonCollection.AddOrReplaceButton(ExcelRange targetRange, String btnID, String label, EventHandler`1 buttonClickHandler)

   at oracle.adf.client.windows.excel.runtime.DIWorksheet.CreateButtons()

   at oracle.adf.client.windows.excel.runtime.DIWorksheet.InitializeUIWithEvents(Boolean isFirstLoad)

   at oracle.adf.client.windows.excel.runtime.DIWorksheet.Initialize(Boolean initializeUI)

Investigation Done

The microsoft excel automatically blocks the VBA trust centre settings for plugins. 

Solution

1. Go to Excel > File > Options > Trust Centre > Trust Centre Settings button > Macro Settings

2. Enable 'Trust access to the VBA project object model' checkbox

Environment

Oracle Fusion Applications 11.1.7