6 ms·
I've done some VBA for work. If I build an Excel file with SharpCells and send them to someone who doesn't have it. What happens when they open it? From what I
by DoctorOW 4y ago
I've done some VBA for work. If I build an Excel file with SharpCells and send them to someone who doesn't have it. What happens when they open it? From what I understand, .NET is pretty easy to decompile. Is it possible to make a SharpCells F# to VBA translation before saving?
- layer8 4y agoVBA is the old win32/COM-based Visual Basic, not .NET, so that might be difficult. I agree that the non-portability of such Excel extensions is a showstopper for many use cases.
- joenathanone 4y agoMicrosoft is currently doing about everything they can to kill VBA.
- sharpcells 4y agoAn F# to VBA translation would be very difficult. The languages are very different and F# relies heavily on the .NET runtime which VBA does not use. When you use Sharp Cells the F# scripts are embedded with the workbook when you save so sending the .xlsx will work for the recipient provided they also have Sharp Cells installed. For many workbooks the free tier would be sufficient for use. If the user doesn't have Sharp Cells the functions won't load and the results relying on Sharp Cells UDFs will be replaced with `#NAME?` errors.