VBA in Excel
Hi George,
Thank you very much for your suggestions! I am trying to
get myself familiar with the Excel Objects, and trying to
read other pepole's sample code.
Thanks,
jen
-----Original Message-----
Since you already know programming in Access, Excel
should be fairly easy to
pick up because you are already familiar with VBA
convetions and functions,
etc. Learning a new object library is the biggest
hurdle you face.
(Remember the Object Browser in the VBE, it is our
friend...)
Excel does have one feature not found in Access that may
make your learning
curve much shorter: the Macro recorder (ToolsMacro).
If you know how to do
something manually, but want to know how to do it in
VBA, turn the recorder
on, do it manually, turn the recorder off, and then look
at the resulting
code (a new standard module is added in the VBE when you
use the recorder
for the 1st time every session. Subsequent recorder uses
*during that
session* will append to that module.)
The macro recorder results are *very* literal and
therefore very ineffecient
as "finished" code. It is as if you were recording
individual keystrokes.
For this reason it will invoke "Select", "Selection"
and "Activate" much
more frequently than is ever necessary in your own code
(these
methods/properties contain a performance hit and can be
avoided 95% of the
time.) Likewise, the recorder results won't use any
conditional or loop
constructs as you would expect to see in "real" code.
However, the recorder
results can be immensely valuable in *quickly* pointing
you in the right
direction when trying to figure out how to do something
within Excel's
object library.
HTH,
George Nicholson
"jen" wrote in
message
...
Hi,
Can anyone recommend me a free website that I can
learn
VBA in Excel? I know programming in Access, but I know
nothing in Excel, I wanted to learn VBA in Excel by my
own.
Thanks,
jen
.
|