Member Avatar for Captain Haddock

Hi,

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)?

Thanks

  • 2 Contributors
  • 2 Replies
  • 111 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Captain Haddock

Recommended Answers

All 2 Replies

Member Avatar for Comatose

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.