Compiling Excel VBA-code?

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Reply

Join Date: May 2006
Posts: 2
Reputation: Captain Haddock is an unknown quantity at this point 
Solved Threads: 0
Captain Haddock Captain Haddock is offline Offline
Newbie Poster

Compiling Excel VBA-code?

 
0
  #1
May 14th, 2006
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
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 2,413
Reputation: Comatose is a jewel in the rough Comatose is a jewel in the rough Comatose is a jewel in the rough Comatose is a jewel in the rough 
Solved Threads: 211
Team Colleague
Comatose's Avatar
Comatose Comatose is offline Offline
Taboo Programmer

Re: Compiling Excel VBA-code?

 
1
  #2
May 14th, 2006
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.
Reply With Quote Quick reply to this message  
Join Date: May 2006
Posts: 2
Reputation: Captain Haddock is an unknown quantity at this point 
Solved Threads: 0
Captain Haddock Captain Haddock is offline Offline
Newbie Poster

Re: Compiling Excel VBA-code?

 
0
  #3
May 25th, 2006
Thanks
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC