Any recommendations for a language that I can compile into unreadable code?

The Bear named Joe

New Member
Joined
Jan 15, 2021
Messages
5
Office Version
  1. 365
I would like your opinion please. I am a developer from the IBM AS400 days. I like vba. But the code for it is viewable and can of course be modified. Most books on VBA claim it is compiled. From my perspective it is not. I say this because the instructions in VBA are open source code. Since VBA does not compile into object code (at least in a way that I am familiar with) is there another language on the PC platform that is similar to COBOL, FORTRAN, RPG etc. and the compiled object code could be portable to another computer while retaining the source code on the development machine? Thanks in advance for your advice. I am hoping for a language that is similar and with a moderate learning curve. Regards...
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Hi there. I am a developer from IBM system/360 Assembler/COBOL days! There are a few VBA compilers out there but they're not free, I saw this one for instance which can create a dll: 10 Steps to compile VBA code to DLL - VbaCompiler for Excel - also Unviewable+ VBA for Excel PowerPoint Word AutoCAD Visio Please note I have no experience of either of these, but the second one claims to be endorsed by MrExcel.

One option depending on what you are trying to develop might be to use Access. Develop the VBA code you want, then you can create a runtime version which is compiled.
 
Upvote 0
Solution
You could look at VB. It is similar-ish to VBA, albeit much more object-oriented. C# is a more popular option, with probably more support available, but would have a slightly steeper initial learning curve. Depending on what you are doing, if you could find a copy of VB6 that would be very similar to VBA (which is basically a subset of VB6) and compiles into executables.
 
Upvote 0

Forum statistics

Threads
1,214,901
Messages
6,122,157
Members
449,068
Latest member
shiz11713

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top