Binary files inside EXCEL VBA

[sancarn]

Ah well, VBA is not a world I ever played in for any significant time. My last bout with VBA was building programs in Access like 20 years ago. I'll defer to you on this if you think this is an approach VBA users find acceptable.

Can confirm, I've done this in the past. Especially when using DLLs like Webview2.dll, MITAB.dll, blas.dll etc.

So you're using Excel as an install tool, or a deployment vector... why not just use an installer? Otherwise you're cutting off a segment of potential users that don't have Excel.

Unfortunately, not everyone has the capability of running msi's on their computer. VBA is highly common in businesses where users aren't able to run installers like you suggest. In these scenarios using VBA as an installer is super ideal. Bare in mind typically in these cases EXEs will also be unable to run, so the primary use case is installing DLLs in my opinion.