Macro Run-Time Error

Question

I have a spreadsheet that my team uses to generate templates by pulling data from our automation systems. It uses a macro to pull the requested information from a file on a server.

To use it, my VPN must be on and macros enabled, I have done both, but it doesn't work on my computer. This macro works on everyone else's computer in my team, except for mine. It just gives me the following error:

Run-time error '-2146234341 (8013101b}:
Could not load file or assembly or one of its dependencies. This assembly is built by a runtime newer
than the currently loaded runtime and cannot loaded.

Can you please tell me how to address this issue and get the macro working?

nikolinode · Answer

sahrens&nbsp;The error message you’re seeing suggests that the macro is trying to load an assembly (a compiled code library) that was built with a newer version of the .NET Framework than the one currently installed on your computer.To resolve this issue, you can try updating the .NET Framework on your computer to the latest version.You can download the latest version of the .NET Framework from the Microsoft website.Once you’ve installed it, restart your computer and try running the macro again.If you continue to experience issues, you may want to reach out to your IT department for further assistance.&nbsp;Hope this will help you.

sahrens · Answer

Thanks for your response, I have downloaded the latest version (.NET Framework 4.8.1) and restarted my computer but I am getting the same error. Is there a way I can check which version of the .NET Framework that the assembly was built with, and check which version I am running to make sure the download worked properly?

Unfortunately my IT department says they won't help with Macro issues and forwarded me here, so I won't be able to get any help from them.

nikolinode · Answer

&nbsp;Do you have Microsoft .NET Framework 3.5 installed on your PC?If not, here are the links with the download and installation.&nbsp;Install the .NET Framework 3.5 on Windows 11, Windows 10, Windows 8.1, and Windows 8Download Microsoft .NET Framework 3.5&nbsp;&nbsp;sahrens

sahrens · Answer

No I have 4.8.1 because that was the newest version available. 3.5 looks to be the oldest available version, which is the opposite of what you first suggested. Is there I reason why I should use 3.5 instead?&nbsp;NikolinoDE&nbsp;

nikolinode · Answer

Framework a working framework (as the name suggests) or a framework of software used by other programs to prevent those programs from reinstalling the same pieces over and over again. Framework is therefore a collection, which can also be called a library, of different drivers or programs, which in turn supports the functions of other programs.This is the "substructure" for many programs.Net 3.5 is actually only installed if a program requires it.NET 4.8 is an integral part of Windows and is required for Windows and other programs.If you decide to uninstall 4.8, you can reinstall Windows.

Forum Discussion

Macro Run-Time Error

7 Replies

Resources