compiling

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.

Regards,
Dax.

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,
Avi