Creating a DLL for Excel

[ExcelMonkey]

Can some one provide me a source highlighting how to create a DLL for Excel.
Nothing specific at this point. I just want to understand how this differs
from options using full code in VBA modules.

I have some general questions around security differences in DLLs vs VBA
Macros.

I have Visual Studio 2008 Express to work with.

Thanks

EM

 

[Simon Murphy]

buy Professional Excel development by Bullen Bovey and Green.
That explains the options well.

Or search MSDN

My attempt to explain is here:
http://www.codematic.net/Excel-development/Excel-Add-ins/excel-add-ins.htm

There are some recent posts in this area on my blog here:
http://smurfonspreadsheets.wordpress.com/2008/09/02/xlls-v-vb6-automation-addins/

Cheers
Simon
Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training

 

[ExcelMonkey]

Thanks Simon. To be clear the two links your provided reference various
types of files. I want to ensure that I know which is refering to a "DLL".
The SmurfsonSpreadsheets speaks to an XLLs. Is this a DLL? And Codematic
refers to Win32 XLL.

For speed would I be forced to to to C++. I am currently in VB.Net?

Thanks

EM

 

[ExcelMonkey]

Sorry, I read through your site some more and bacially answered my questions:

"Fundamentally an xll is just a renamed dll"

Great site by the way.

Thanks

EM