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

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

Or search MSDN

My attempt to explain is he
http://www.codematic.net/Excel-devel...el-add-ins.htm

There are some recent posts in this area on my blog he
http://smurfonspreadsheets.wordpress...mation-addins/

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


ExcelMonkey wrote:
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

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



"Simon Murphy" wrote:

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

Or search MSDN

My attempt to explain is he
http://www.codematic.net/Excel-devel...el-add-ins.htm

There are some recent posts in this area on my blog he
http://smurfonspreadsheets.wordpress...mation-addins/

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


ExcelMonkey wrote:
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

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

"Simon Murphy" wrote:

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

Or search MSDN

My attempt to explain is he
http://www.codematic.net/Excel-devel...el-add-ins.htm

There are some recent posts in this area on my blog he
http://smurfonspreadsheets.wordpress...mation-addins/

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


ExcelMonkey wrote:
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