MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Avi on August 01, 2001 6:24 AM

Is it possible to compile a workbook with macros into a .exe file or any other self containing file?

Posted by Dax on August 01, 2001 7:11 AM

It's not possible to compile VBA into machine code. However, what you could do is create the code you want using Visual Basic or MS Office Developer and then compile this into an executable or dynamic link library (dll file). You could then reference this from within your code. To be honest, it's quite a lot of effort and the performance increase won't be spectacular.


Posted by Avi on August 03, 2001 8:56 AM

Do you mean creat the macros in VB code? and then refrence it from with in a VB Program? I basicly want to use a spreadsheet in a program where the destination computer doesn't have to have excel installed. The program will be VB, are there any spreadsheet libraries? I know it's a lot of questions but i would be grate to any answers. Thank You,