is there a way to write stand alone programs (without excel) using the same
code as is used w/in excel vba?
the only "programming" i have done is w/in excel in the visual basic editor.
i have come a long way in my abilities to create almost anything i need w/in
the framework of excel (sometimes w/ help from this group). but all of my
"programs" are really .xls files, even though the spreadsheets themselves
contain no formulas (all formulas are in code). the spreadsheets are only
used for inputs, buttons to call the code, and output.
i am familiar w/ the term "compiler" that a friend had for his C++ code and
from another friend who has visual fox pro, which he showed me how he writes
his code, sends that stand alone program to his customers along w/ a dll
(library of functions?) and his customers can run it w/out actually having
fox pro, excel, etc.
i kind of think microsoft has a product called visual basic that may be a
compiler, much like the above examples, but am totally unsure. bottom line:
is there a way i can use the code and knowledge i have w/ excel's vba in a
stand alone program? (note, i rely on many built-in functions--vlookup,
match, left, isnumeric, etc.-- and would not want to have to re-create them
myself). thanks, mike allen