excel vba creates error message after upgrade to windows 11

Question

after a window 10 to win11 upgrade excel vba blocks access to oracle database. the vba runs without problems on windows 10.

Answer 1

Hi,

It seems that after upgrading from Windows 10 to Windows 11, your Excel VBA is encountering issues when trying to access the Oracle database. This problem wasn't present when you were using Windows 10. I suggest you try these methods to help you troubleshoot this problem:

1. Check for Error Messages: Identify the specific error message that Excel VBA is generating. This can provide clues about what might be going wrong.
2. ODBC Driver Issues: Sometimes, the issue might be with the Oracle ODBC driver rather than Excel itself. Ensure that you have the latest version of the Oracle ODBC driver installed.
3. Macro Settings: Verify that the macro settings in Excel are correctly configured. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and ensure that the box for "Trust access to the VBA project object model" is checked.
4. Reinstall or Update Excel: If the problem persists, consider reinstalling or updating Excel to ensure that all components are correctly installed and up to date.

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.