 |  |  |  |  |  |  |  |
Compiling Excel VBA-code?
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
•
•
Join Date: May 2006
Posts: 2
Reputation: 
Solved Threads: 0
Newbie Poster
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
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
•
•
Join Date: Dec 2004
Posts: 2,413
Reputation:
Solved Threads: 211
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.
|
Similar Threads
- Excel vba 6.0 copy date cells date format (Visual Basic 4 / 5 / 6)
- VBA source code (Visual Basic 4 / 5 / 6)
- Hoping for Help - Import File into Excel (Visual Basic 4 / 5 / 6)
- Excel solver using VB6 (Visual Basic 4 / 5 / 6)
- generating excel chart in VBA (Visual Basic 4 / 5 / 6)
- Converting code for Excel/Windows to code for Excel/mac (Mac Software)
- VB and Excel Programming (VB.NET)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Opening PowerPoint and adobe files in VB
- Next Thread: Linking Excel up with VB6
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
