Creating a DLL for Excel
 

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

Creating a DLL for Excel
 

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

Creating a DLL for Excel
 

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

Creating a DLL for Excel
 

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