$100 is not

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mike allen" wrote in message
...
what is "visual basic.net 2003 standard edition?" i see it on microsoft
website, but is only $100, so that must not be what i am looking for.
thanks, mike allen

"Bob Phillips" wrote in message
...
You will also have to buy Visual Basic, it is not a cheap product.

You might try getting a pre-used copy of VIBE on eBay.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jill E" wrote in message
.. .
Mike,

Yes, Microsoft does have a program called Visual Basic which allows
you
to
create standalone programs. It will support most of your VBA code,
with
some
differences. Most VB manuals will give you some info on how to convert
between the two. You will probably have to identify Excel as an object
and
then use this prefix on the lines of code which are Excel-specific.

Hope that helps,

Jill E

"mike allen" wrote in message
...
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