Forum Discussion

Kennedy Mawole's avatar
Kennedy Mawole
Copper Contributor
Oct 17, 2018

Run time error 1004 when downloading standard template from Oracle database

Hi,

 

I am downloading an ADI template which I will use to upload the data into Oracle Database later. I am getting an error and when debugging the message says;

 

 BneAddReference ThisWorkbook.VBProject, "VBIDE", "{0002E157-0000-0000-C000-000000000046}"

 

Anyone to help on this?

Macros and VBA

1 Reply

Sort By
  • ComputerHabit's avatar
    ComputerHabit
    Copper Contributor
    Oct 30, 2023
    Hello. This is an old post I know. I just found it.

    I resolved this in Excel by allowing "Trust access to the VBA project object model" in the Trust Center Macro Settings.

Resources