A question on vba

D

dalei

I have Excel 2000 installed in my computer, and probably need to do
some vba programming. I have no experience at all. My first question
is: does the vba come with Excel, or is it a separate software that I
have to purchase and install?

Thanks.
 
D

David McRitchie

Hi Dale,
VBA comes with Excel. Change Security level from High to Medium
Tools, Macros, Security, Medium

Getting Started with Macros and User Defined Functions
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Some Examples of Macros in (see my excel.htm page as well)
http://www.mvps.org/dmcritchie/excel/proper.htm
http://www.mvps.org/dmcritchie/excel/join.htm
Links to tutorials:
news://msnews.microsoft.com/microsoft.public.excel.programmin

Some other websites with macros (and worksheet function usage)
http://www.cpearson.com/excel/topic.htm
http://www.contextures.com/tiptech.html
http://www.j-walk.com/ss/excel

The programming group for macro coding is, where you would
be expected to have installed a macro and to have used it, once
you've done that that is the place specifically for macros.
news://msnews.microsoft.com/microsoft.public.excel.programming

BTW, most questions people ask have been asked and answered before,
and answers to most questions not specifically asked before can also be
assembled from information from searching Google Groups.
http://www.mvps.org/dmcritchie/excel/xlnews.htm

Excel Help and VBE (editor) Help are actually separate, you have to
enter Help from where you use it.
 
F

Fastbike

It comes with the software.

Alt-F11 will bring it up.

Or go to Tools, Macros, Visual Basic Editor
 
A

aaron.kempf

yeah.. Excel VBA _DOES_ come with a cost-- basically you'd be a lot
better off doing things with SQL and temp tables; spreadsheets are just
too ridiculous to really do anything important with.

i mean-- xls just doesnt scale; it doesn't work.. it isn't portable...
it isn't printable.. it's not secure.


it's not a product that should be used in the real world under and
circumstance
 
A

Amedee Van Gasse

In <[email protected]>,
[email protected] told us an interesting story. My reply to this
story is at the bottom of this message.
yeah.. Excel VBA DOES come with a cost-- basically you'd be a lot
better off doing things with SQL and temp tables; spreadsheets are
just too ridiculous to really do anything important with.

i mean-- xls just doesnt scale; it doesn't work.. it isn't portable...
it isn't printable.. it's not secure.


it's not a product that should be used in the real world under and
circumstance
Click to expand...

This can be said about all software.

All together now:

ALL HARDWARE SUCKS,
ALL SOFTWARE SUCKS. [*]

As everybody who has worked longer than 5' with any computer knows.



















[*] but some suck more than others...
 
Top