Forum Discussion

sahrens's avatar
sahrens
Copper Contributor
Apr 05, 2023

Macro Run-Time Error

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 ...
Macros and VBA
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Apr 06, 2023

sahrens 

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.

 

Hope this will help you.

sahrens's avatar
sahrens
Copper Contributor
Apr 06, 2023
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.
    • sahrens's avatar
      sahrens
      Copper Contributor
      Apr 07, 2023

      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? NikolinoDE 

      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor
        Apr 09, 2023
        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.

Resources