Reply to thread

Message

[QUOTE="EagleOne, post: 6391232"]
2003, 2007

I believe I have the s/w but not the process to get my VBA into a DLL file

I now have C++ and have successfully compiled some Math-example program written in C++ into a DLL
which can be called by VBA in Excel.  So far so good!

What is missing is what I want to accomplish - which is to protect my current VBA code.

What steps do I have to take to be able to drop my VBA (Excel) code into a C++  via Win32 Console
Application Project and then ending up with an Com Addin of a DLL?

As I see it there must be a way to get my VBA into C++ to end up with a DLL:

Plan A                                                                       Plan B
1) have VBA code (Excel)				1) VBA code
2) Possibly save that code as a .xla file?			2) Drop into VB.NET and/or C++
3) Compile into DLL?   (With what? and how?)		3) Compile into a DLL
4) Call new DLL from Excel VBA				4) Call DLL new from Excel VBA

I have a LInk to Chip Pearson's site and his information is excellent.  That said, where does my
current VBA code get into the mix?

Any Thoughts appreciated!
EagleOne
[/QUOTE]

Verification