9,622 questions
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.
error in VBA office 365 with CreateObject
![](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)
factsjim
1
Reputation point
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,
Microsoft 365 and Office Install, redeem, activate For business Windows
Developer technologies Visual Basic for Applications
1,507 questions
1 answer
Sort by: Most helpful
-
Oskar Shon 866 Reputation points2022-11-09T21:47:38.297+00:00 -
![](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)
Marcin L 0 Reputation points2024-04-10T07:35:33.2566667+00:00 "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.
Sign in to comment -