This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 0%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
I developed an Excel application with VBA to connect to an Oracle Database.
The command CreateObject("OracleInProcServer.XoraSession") works fine in the pre 365 version of Excel.
Since the migration to Excel 365 64 bit, I get an error on this statement.
Please help,
Did you sure if that library is installed on new machine and the name of you're control looks the same?
On 64 and 32 for CreateObject has no deference.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 68%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
"On 64 and 32 for CreateObject has no deference."
This is not ture.
CreateObject("OracleInProcServer.XoraSession") works in 32bit, and doesn't work in 64bit since it uses Oracle Objects for OLE - which only exists in 32 bit Oracle client.