Excel Spreadsheet Compiler?

[mrprobit]

Sorry to necro this thread, but been following it for quite a few years now, as have others.

Any thoughts on this product ?

xlCompiler - Compile Spreadsheet to Application

claims to compile to .exe and support VBA.

I've run some simple spreadsheets, seems to do what it says on the tin on simple sheets. Although it did fail to recognise some simple functions, (poisson and gammaln), not a biggee as these are fairly easy to recreate either on the sheet or on the code.

Anyone have any experience with this software ?

[Roger B]

^^ I've just tried it on a spreadsheet with loads of control buttons and macros and it failed miserably.

Some buttons didn't respond and text in some cells didn't show up.

https://www.flickr.com/photos/rtbcom...57667013431733

[★ CharliCao]

any comments on the lockXLS on its copy protection? I haven't used it before but am interested in it.

[bs0d]

Here are two additional options. While they're not compilers, they will protect your VBA:

• Unviewable+
Unviewable+ VBA for Excel PowerPoint Word AutoCAD Visio - Spreadsheet1 | Excel in your office!
• Secure++
Secure++ VBA Compiler for Microsoft Office Excel - Spreadsheet1 | Excel in your office!

Multiple layers of protection strengthen security. So you can prevent your code from being viewed (unviewable), and obfuscate (secure++) in the unlikely? event the protection is broken.

Other free alternative options for obfuscation include:

• Invisible Basic: Invisible Basic
• CrunchCode (no longer supported): CrunchCode – the obfuscator for VBA macros

[craigpritchardweb]

I, too, am looking for an effective spreadsheet compiler in order to protect VBA code of apps that may well become commercial products. They are heavy on macros and database connections, so need to survive the compilation process.

I tried xlCompiler, which as suggested before, was a long way short of requirements. However, it ran without needing to open Excel, which is something that would be desirable to remove that dependency. LockXLS also seems to have problems with database connections and queries but otherwise seems to be an improvement on xlCompiler, although it does require that the user have Excel. The likes of Unviewable+ and Secure++ don't seem to fulfill all of the requirements I have of a spreadsheet compiler.

DoneEx has a trojan lurking within its files, so that's obviously a non-starter and strongly recommend nobody use it. Luckily I have sufficient anti-virus measures to ensure it was picked up before it infecting anything of my system.

Is there ANY spreadsheet compiler out there that can do everything I intend?

[NdNoviceHlp]

This might be helpful... https://www.mrexcel.com/forum/excel-...light=resource
To get the MAC address U need to loop through the ports until U find it. HTH. Dave

[craigpritchardweb]

Thanks for your reply Nd. Is there another way of getting the Resource Editor add-in for Excel without downloading Visual Studio? As I don't think downloading/buying VS is really an option on this system unless its the Community version and it somehow has that?

PS: I use Excel 2016 on this system.

[craigpritchardweb]

Can I get an answer on my previous question please? Cheers.

[NdNoviceHlp]

I have no idea re. "another way of getting the Resource Editor add-in for Excel without downloading Visual Studio". I just know my copy of VB6 was "free". Not sure that this approach would help U anyways. U still need office installed. U can use VB6 to install and operated the XL wb. From VB6, U can insert sensitive formulas etc. into the wb on open and then remove them before saving the wb. U can also place your sensitive macros within the VB6 code to effect changes on the wb. U can also operate the wb with userform only access so as to prevent users accessing the wb during operation. The utility of this approach depends upon what U want to do. The wb file may or may not remain in the file directory depends on whether U need to store data within the wb. Anyways, there's some interesting stuff at the link below. Have a nice day. Dave

http://www.vbaexpress.com/forum/show...via-VBA-editor

[mandukes]

any comments on the lockXLS on its copy protection? I haven't used it before but am interested in it.

I have LockXls and its the worst. the excel file is not protected entirely. There is a way to extract the excel form the exe it creates but would not share it here..