Yes and no. One could write a dll in C, C++, C#, J#, or even VB.NET or VB6. They're basically a pre-compiled object or library that when referenced is used with other APIs. The problem with macros is that they are compiled at run-time. So in essence whenever you use a macro for the first time, it needs to be compiled, making it less efficient.
Another advantage of dlls is the ability to share a tool with someone else without revealing the code behind it. I'm completely for open source systems, but for corporate IP issues, this is an advantage.
I hope this helps a bit
Andy
Originally Posted by gus
I thought the benefit of DLLs were that they were developed in C and were therefore a lot faster than the use of ordinary Excel macros?
I was also under the impression that in Windows you could either use the ordinary macros or DLLs. If you had something that was processor intensive and you wanted speed, then you would use DLLs. Is there an equivalent for Mac or am a wrong about the purpose of DLLs?
Cheers
Neil