|
PureBytes Links
Trading Reference Links
|
Hi Ed
Glad to hear that you like Walkenbach's book ... I'm currently enjoying the
"writing a procedure to call / run another procedure" section. Great idea to
have a "meta" program that calls modular programs ... but confusing to
figure out which is the "calling" and the "called" procedure ... or the
"runner" and the "runnee" procedure <G>.
Best regards
Walter
Here's some comments from an earlier post re VBA books:
================
"Excel 2000 VBA Programmers Reference" at
http://www.wrox.com/Store/Details.asp?Code=2548
Walkenbach's "Excel 2000 Power Programming with VBA"
at www.idgbooks.com
and
"SAMS Teach Yourself Microsoft Excel 2000 Programming in 21 Days" by Matthew
Harris at www.samspublishing.com
The reference book is a fast and easy way to find out the scope / extent of
the objects and methods of a "part" of a Excel that you want to program.
Walkenbach's book is much more orientated to using Excel features to their
maximum extent. Lots of tips and tricks here. Easy to read and understand.
It is fast paced and will definitely not put you to sleep.
The SAMS 21 day course is great for the non-programmer like myself. For
example simple VBA / programming terminology will drive you nuts on a
regular basis. Programmers will talk about "calling" a procedure ... SAMS
was
the only book to tell me that to "call a procedure" is the same as to "run a
procedure".
Free VBA "book" / materials at
http://www.microsoft.com/officedev/articles/Opg/toc/pgtoc.htm
========================
----- Original Message -----
From: Ed Middleton <emiddleton@xxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Friday, September 03, 1999 9:26 AM
Subject: Re: VB
| Walter and others,
|
| I have not been following these threads on VB for Excel but I presently am
| learning it so as to be able to perform backtesting of Mechanical screens
| for stock selection. I have found a very good book that you guys might
want
| to look into:
|
| Microsoft Excel 2000 power programming with VBA by John Walkenbach
|
| I just upgraded to 2000 so this is the one for me but he has written
similar
| versions for Excel 95 and Excel 97. Check out amazon for some
descriptions
| on his books. It was available at my local Chapters.
|
| I'm about 1/4 of the way through the book at have found the read very easy
| with great examples. The 2000 version (I'm not sure about the others)
comes
| with a CD full of examples organized by the chapter in the book. I highly
| recommend this book.
|
| Ed
|
|
| ----- Original Message -----
| From: Walter Lake <wlake@xxxxxxxxx>
| To: Metastock bulletin board <metastock@xxxxxxxxxxxxx>
| Sent: Friday, September 03, 1999 7:34 AM
| Subject: VB
|
|
| > Hi Adam, Lars, et al
| >
| > Here's a free Chapter 1 that will help to give you a very quick
"dunking"
| > into the world of actually programming a project.
| >
| > http://www.murach.com/books/VB60/chapter.htm
| >
| > When you print it out ... it's set up so that the text goes on the left
| and
| > the instructions and screens go on the right.
| >
|