2003, 2007

I have a VBA Procedure that I would like to compile into a DLL which can be called from an Excel
macro so that I can protect the original source VBA code.

A working example would be great as that is the way I learn best.

Any thoughts, examples, plan of attack, links greatly appreciated.

TIA EagleOne

Try Chip Pearson's site.

http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

Or

http://www.cpearson.com/excel/automationaddins.aspx



Gord Dibben MS Excel MVP


On Sat, 16 May 2009 19:47:11 -0400,
wrote:

2003, 2007

I have a VBA Procedure that I would like to compile into a DLL which can be called from an Excel
macro so that I can protect the original source VBA code.

A working example would be great as that is the way I learn best.

Any thoughts, examples, plan of attack, links greatly appreciated.

TIA EagleOne

Thanks Gord.

The examples on Chip's site use VB 6. When I became interested in compiling VBA, I was told that VB
6 was/is on the way out. Therefore I got Visual Studio C+.

Do you have any thoughts on where I can get similar information (Chip's info) for C+? I have no
experience with any code other than VBA.

TIA EagleOne


Gord Dibben <gorddibbATshawDOTca wrote:

Try Chip Pearson's site.

http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

Or

http://www.cpearson.com/excel/automationaddins.aspx



Gord Dibben MS Excel MVP


On Sat, 16 May 2009 19:47:11 -0400,
wrote:

2003, 2007

I have a VBA Procedure that I would like to compile into a DLL which can be called from an Excel
macro so that I can protect the original source VBA code.

A working example would be great as that is the way I learn best.

Any thoughts, examples, plan of attack, links greatly appreciated.

TIA EagleOne

you're incorrect, Chip also does a DLL in VB.NET which works perfectly
well - I just ran the code - and the DLL runs fine in Excel 2003 and in
Excel 2007

http://www.cpearson.com/Excel/creati...nctionlib.aspx






wrote in message
...
Thanks Gord.

The examples on Chip's site use VB 6. When I became interested in
compiling VBA, I was told that VB
6 was/is on the way out. Therefore I got Visual Studio C+.

Do you have any thoughts on where I can get similar information (Chip's
info) for C+? I have no
experience with any code other than VBA.

TIA EagleOne


Gord Dibben <gorddibbATshawDOTca wrote:

Try Chip Pearson's site.

http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

Or

http://www.cpearson.com/excel/automationaddins.aspx



Gord Dibben MS Excel MVP


On Sat, 16 May 2009 19:47:11 -0400,
wrote:

2003, 2007

I have a VBA Procedure that I would like to compile into a DLL which can
be called from an Excel
macro so that I can protect the original source VBA code.

A working example would be great as that is the way I learn best.

Any thoughts, examples, plan of attack, links greatly appreciated.

TIA EagleOne

"Patrick Molloy" wrote:

you're incorrect, Chip also does a DLL in VB.NET which works perfectly
well - I just ran the code - and the DLL runs fine in Excel 2003 and in
Excel 2007

http://www.cpearson.com/Excel/creati...nctionlib.aspx






wrote in message
.. .
Thanks Gord.

The examples on Chip's site use VB 6. When I became interested in
compiling VBA, I was told that VB
6 was/is on the way out. Therefore I got Visual Studio C+.

Do you have any thoughts on where I can get similar information (Chip's
info) for C+? I have no
experience with any code other than VBA.

TIA EagleOne


Gord Dibben <gorddibbATshawDOTca wrote:

Try Chip Pearson's site.

http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

Or

http://www.cpearson.com/excel/automationaddins.aspx



Gord Dibben MS Excel MVP


On Sat, 16 May 2009 19:47:11 -0400,
wrote:

2003, 2007

I have a VBA Procedure that I would like to compile into a DLL which can
be called from an Excel
macro so that I can protect the original source VBA code.

A working example would be great as that is the way I learn best.

Any thoughts, examples, plan of attack, links greatly appreciated.

TIA EagleOne

Hello Pat,

I did see the reference to VB.NET but I do not have that? (Maybe VB.NET is a subset of C or
vice-versa)


"Patrick Molloy" wrote:

you're incorrect, Chip also does a DLL in VB.NET which works perfectly
well - I just ran the code - and the DLL runs fine in Excel 2003 and in
Excel 2007

http://www.cpearson.com/Excel/creati...nctionlib.aspx






wrote in message
.. .
Thanks Gord.

The examples on Chip's site use VB 6. When I became interested in
compiling VBA, I was told that VB
6 was/is on the way out. Therefore I got Visual Studio C+.

Do you have any thoughts on where I can get similar information (Chip's
info) for C+? I have no
experience with any code other than VBA.

TIA EagleOne


Gord Dibben <gorddibbATshawDOTca wrote:

Try Chip Pearson's site.

http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

Or

http://www.cpearson.com/excel/automationaddins.aspx



Gord Dibben MS Excel MVP


On Sat, 16 May 2009 19:47:11 -0400,
wrote:

2003, 2007

I have a VBA Procedure that I would like to compile into a DLL which can
be called from an Excel
macro so that I can protect the original source VBA code.

A working example would be great as that is the way I learn best.

Any thoughts, examples, plan of attack, links greatly appreciated.

TIA EagleOne

VB.NET is the NET language that VB6 will be replaced by.
You need to install MS Visual Studio 2005 or 2008

VB.Net, C# and C++ are supplied with this, but .NET allows many more
languages



wrote in message
...
Hello Pat,

I did see the reference to VB.NET but I do not have that? (Maybe VB.NET
is a subset of C or
vice-versa)


"Patrick Molloy" wrote:

you're incorrect, Chip also does a DLL in VB.NET which works perfectly
well - I just ran the code - and the DLL runs fine in Excel 2003 and in
Excel 2007

http://www.cpearson.com/Excel/creati...nctionlib.aspx






wrote in message
news:f8nu051rk109f001qp4c32u13v0fopa
...
Thanks Gord.

The examples on Chip's site use VB 6. When I became interested in
compiling VBA, I was told that VB
6 was/is on the way out. Therefore I got Visual Studio C+.

Do you have any thoughts on where I can get similar information (Chip's
info) for C+? I have no
experience with any code other than VBA.

TIA EagleOne


Gord Dibben <gorddibbATshawDOTca wrote:

Try Chip Pearson's site.

http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

Or

http://www.cpearson.com/excel/automationaddins.aspx



Gord Dibben MS Excel MVP


On Sat, 16 May 2009 19:47:11 -0400,
wrote:

2003, 2007

I have a VBA Procedure that I would like to compile into a DLL which
can
be called from an Excel
macro so that I can protect the original source VBA code.

A working example would be great as that is the way I learn best.

Any thoughts, examples, plan of attack, links greatly appreciated.

TIA EagleOne

The examples on Chip's site use VB 6. When I became interested in compiling VBA, I was told that VB
6 was/is on the way out. Therefore I got Visual Studio C+.

As noted, I also have VB.NET examples of an automation add-in (NET
ClassLib project). Even though VB6 is on its way out (or already is
out, depending on who you ask), it still provides more and better
functionality than VBA ever will. (VBA, too, is on the way out. The
language hasn't been updated in nearly a decade. In the future, some
incarnation of NET is going to supplant everything.) If you don't
already have VB6 or don't have an MSDN subscription, obtaining VS6 may
be a challenge.

The nice thing about using the NET framework is that it doesn't really
matter what language you code in and that the functional requirements
of an application don't generally dictate much about which language to
use. If you're good in VBA and/or VB6, VB.NET is reasonably easy to
learn. If you're a C/C++ person, you could use C++ or C#. You can
even use COBOL if you're really nuts for it.

If you're going to be writing automation libraries, you can do that
with straight NET code, whichever language you prefer. For add-ins,
though, you'll probably want to use Visual Studio Tools For Office.
This is a separate product for Visual Studio 2003 and VS2005, but it
included integrated into VS2008 as part of the package. The real
problem when writing what are called "code behind" workbooks is that
if you have Excel 2007 installed on your system, you can create only
2007 code-behind applications. Even if you have both XL 2003 and 2007
installed, you can still create only 2007 projects due to the way
interoperability is handled. (I use a VM running Windows XP with
Office 2003 only if I need it.) Various press reports say, though,
that this limitation will be remedied in VS2010 or whatever comes
after VS2008.

If you are aiming to write commercial quality code-behind or add-ins
for Office using NET, I would strongly recommend Add-In Express For
NET 2008 and Add-In Express For VSTO 2008
(http://www.add-in-express.com). These project prototypes and their
attendant assemblies make writing NET for Office much simpler, and
extend what is possible using NET/Office alone. It also overcomes the
2003/2007 interoperability problems. AIX can also automatically create
a setup/deployment package that is much better than Microsoft's. AIX
also supports creating XLL add-ins on the new Office 12 standard.



Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 16 May 2009 20:44:25 -0400,
wrote:

Thanks Gord.

The examples on Chip's site use VB 6. When I became interested in compiling VBA, I was told that VB
6 was/is on the way out. Therefore I got Visual Studio C+.

Do you have any thoughts on where I can get similar information (Chip's info) for C+? I have no
experience with any code other than VBA.

TIA EagleOne


Gord Dibben <gorddibbATshawDOTca wrote:

Try Chip Pearson's site.

http://www.cpearson.com/excel/CreatingCOMAddIn.aspx

Or

http://www.cpearson.com/excel/automationaddins.aspx



Gord Dibben MS Excel MVP


On Sat, 16 May 2009 19:47:11 -0400,
wrote:

2003, 2007

I have a VBA Procedure that I would like to compile into a DLL which can be called from an Excel
macro so that I can protect the original source VBA code.

A working example would be great as that is the way I learn best.

Any thoughts, examples, plan of attack, links greatly appreciated.

TIA EagleOne

A couple of links you might find useful:

http://newtonexcelbach.wordpress.com...ng-excel-to-c/

http://newtonexcelbach.wordpress.com...-excel-to-c-2/

Thanks Doug

Dougaj4 wrote:

A couple of links you might find useful:

http://newtonexcelbach.wordpress.com...ng-excel-to-c/

http://newtonexcelbach.wordpress.com...-excel-to-c-2/

What a great name-concept for your site!

Dougaj4 wrote:

A couple of links you might find useful:

http://newtonexcelbach.wordpress.com...ng-excel-to-c/

http://newtonexcelbach.wordpress.com...-excel-to-c-2/