Converting VBA code into an Executable

Hi!

We have a number of Excel workbooks with an array of code contained within them. We would like to develop a number of common utilities and I was wondering whether it was possible to create an Executable binary that could be deployed onto a machine directly.

Does anyone have any experience of this process? What tools and other factors should I consider?

Many thanks!

R

Since VBA is a part of EXCEL (or Word) you CAN NOT create .EXE-type files. The code developed is only usable with the .XLS-files it belongs too.

Only if your running the Developer version of Office can you compile vba code into exe's.