A user was trying to running a macro within an excel sheet, but when doing so, we run into the error of excel saying it’s a -1004 runtime error. Upon further digging, we discover that the issue bounces back with a No ODAC driver found issue. Then we looked at the ODAC drivers, and found that on the computers that where the sheet marco’s worked, it had the “Oracle in 12.2” (the highlighted yellow) driver installed. However, we cannot seem to find where to install that driver. We are running office 32-bit version as well.
[List of drivers from another working computer] (https://i.sstatic.net/kZpEl5mb.png)