Run time error 1004 when downloading standard template from Oracle database

Copper Contributor

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?

1 Reply
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.