VBA becomes run-time error 424 after Office version upgrade

ringo55 10 Reputation points
2023-01-18T08:13:08.4333333+00:00
After Office upgrade (Version 2212 (Build 15928.20198))
If you import a standard module with VBA and execute a function in that module with call

A run-time error 424 has occurred.

  Importing with ThisWorkbook.VBProject.VBComponents.Import file path.

 

as a side note

In the previous version version 2211 (build 15831.20208) it did not give a runtime error.


I would appreciate it if you could check if it will be supported in future versions.

Thank you.
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,955 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,977 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.