error in VBA office 365 with CreateObject

factsjim 1 Reputation point
2022-09-01T13:59:30.45+00:00

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,

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,007 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oskar Shon 866 Reputation points MVP
    2022-11-09T21:47:38.297+00:00

    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.