"mike allen" wrote in message
...
if the developer and the user both have to have excel, then why use Visual
Basic 6.0, etc., vs. just excel and vba?

Because then the user only gets the compiled code


i am just seeing if there is a way to present something more
"professional"
by creating a stand alone program. most of my
applications/programs/customized spreadsheets (whatever they are properly
called) are very complicated w/ involved math, have no spreadsheet
formulas
(only code), very protected from tampering, etc. and deserve more credit
than to be called "a spreadsheet" or "an excel file", which is what one of
my users calls it. in a way, he is right, but if it were stand-alone, it
would be the real thing: a bona fide program. how would you defend a
very
involved set of macros, functions, etc. that happens to be contained in
excel, and what do you call this? a program, an excel application, an
excel
file, a customized spreadsheet...? thanks, mike allen

I have exactly the same problem and use a com addin which is
a compiled dll instead of VBA

http://msdn.microsoft.com/library/de...mso2kaddin.asp

Keith