I have developed an application in Excel 2002/XP to handle a spreadsheet.In order to make the execution faster I want to compile the VBA-code into mashinecode. The Visual Basic Editor in Excel can only find compiling errors, but not compile. The application works fine, but I want it to be faster.

- Which tool/s do I need to compile code written in Excel 2002 and 2003?
- Are there any free downloads so I can try out the technique before bying something?
- Is there any software that only compiles (I actually don’t need a complex developing environment)?


As far as I know you can't. I believe you could port your source to VB6 with minor modifications, and then compile the EXE from VB, but I'm pretty sure that VBA (macro's and such) are interpreted, and must remain that way.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.