Unsuccesful installation of VBA Compiler

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
Solved652 views
0

Dear madam, dear sir,

I came across your VBA compiler via https://analystcave.com/vba-compiler-add-in-to-vb-net/#VBA_Compiler_Installation and I am very interested to test it out as I have developed a huge excel program that depends on VBA and needs a boost in performance.

However the compiler installation instructions are not working for me.

The tab VBA Compiler will not become visible in Excel 2016 (x86, Windows 10 64-bit).

Following your instructions the following issues were displayed:

1. Microsoft .NET Framework 4.5:
Microsoft .NET Framework 4.5 is already a part of this operating system. You do not need to install the .NET Framework 4.5 redistributable.
As such I left the current .NET Framework in tact by canceling this installation.
Running the Microsoft supplied script in the powershell gives info about .NET Framewok which appears to be higher in version (4.7.2):
.\DetermineNetframeworkVersion.ps1
.NET Framework 4.7.2
.NET Framework 3.5 service pack 1
.NET Framework 3.0 service pack 2
.NET Framework 2.0 service pack 2

2. Windows SDK install complaints that:
Some Windows SDK components require RTM.NET. Setup detected a pre-release version of the .NET Framework 4.
I succeeded the remaining SDK components installation.

3. After this I installed the VBA Compiler (32bit) as my Office 2016 is 32-bit. The VBA compiler did not appear after restarting Excel however.

4. Whenever I run COM Add-ins from the Developer tab, the VBA Compiler is shown in the list, but not checked as ‘Load at Startup’. Checking this will not lead to loading at startup. It is shown again as unchecked after showing the COM Add-ins dialog again. Whenever I tried to add VBA Compiler to the COM Add-ins list using the path “C:\Program Files (x86)\AnalystCave\VBA Compiler\ExtractDLL.dll” a dialog is shown indicating the dll is not a valid Office Add-in.

5. VBA Compiler is also shown as Excel Options in the Add-ins menu listing.

Do you know what is wrong?

Thank you for your support.

With kind regards,
Jeroen Snel

Selected answer as best
0

Dear Readers, I am sorry but the VBA Compiler has stopped working since updates to the Microsoft SDK and runtime. I am trying to collate all the files used to submit the files to GitHub but as this stopped working frankly I deprioritized this currently.

I recommend you read instead my post on how to use C# in Excel VBA. The VBA Compiler basically replicated this capability automatically but still you can easily reuse most of you VBA code to create a DLL.

Posted new comment
Avatar

Hi Tom

Can you release the code and knowlage of HOW to translate vba to .net?
That would be really great!

Thanks

0

Have the same problem.

Windows 10 64bit and Office 365 64bit.

No Compiler menu, I can only see something call “Microsoft Action Pane 3” in XLM-Add ins.

Answered question
0

I tried to install and run VBA Compiler on another Windows 10 computer using Excel 2010 with the same result.

0

I am having the same issue. In the COM Add-ins dialog box from the Developer tab it says:

Load Behavior: A runtime error occurred during the loading of the COM Add-in.

I am using Windows 10 Pro 64 bit version 1803 and Excel Office 365 Business version 1901.

Simply the best place to learn Excel VBA