Advice/Help

Can anyone recommend any good websites or books regarding learning VBA?


Thanks in advance

Barry

Howard
Sat Jul 03 15:09:12 CDT 2004

For VBA, one needs to select a VBA book for the app of their choice.

For MSFT Word, see the list WordVBA books at my URL below. I'd suggest
Steve Roman's Writing Word Macros.

For Excel, see John Walkenbach's books
(http://www.j-walk.com/ss/books/index.htm) and the book at
http://www.bmsltd.ie/BMSPage.htm#Books.

For Outlook, see Sue Mosher's book
(http://www.outlookcode.com/jumpstart.aspx).

--
http://www.standards.com/; See Howard Kaikow's web site.
"Barry" <barry.morenospam@virgin.net> wrote in message
news:sLEFc.289$757.204@newsfe3-gui.ntli.net...
> Can anyone recommend any good websites or books regarding learning VBA?
>
>
> Thanks in advance
>
> Barry
>
>

Peter
Sat Jul 03 17:50:21 CDT 2004

Hi Barry

In addition to Howard's suggestions, there's these:


http://www.computorcompanion.com/LPMArticle.asp?ID=22
Part 1: Learn to create professional looking forms in Word.
by Dian Chapman
[Copyright (c) Logical Expressions, Inc.]
http://www.computorcompanion.com/LPMArticle.asp?ID=46
Part 2: Add Automation to your Word forms.
by Dian Chapman
[Copyright (c) Logical Expressions, Inc.]

http://www.computorcompanion.com/LPMArticle.asp?ID=119
Part 3: Learn more VBA (macros) to automate your forms.
by Dian Chapman
[Copyright (c) Logical Expressions, Inc.]

http://www.computorcompanion.com/LPMArticle.asp?ID=127
Part 4: Lean how to use dialog boxes in your Word forms.
by Dian Chapman
[Copyright (c) Logical Expressions, Inc.]

http://www.computorcompanion.com/LPMArticle.asp?ID=136
Part 5: Connect your AutoForm to a database to save input time and keep
better records!
by Dian Chapman
[Copyright (c) Logical Expressions, Inc.]

and of course:

1. Make sure you have the Word VBA online help installed, if not - Do it now!
2. Make use of and familiarise yourself with the VBA IDEs Object Browser (F2)
3. Use the MVP website: http://word.mvps.org/index.html
4. Use the Google News Group search feature

The only book on VBA I'd ever recommend is:

Visual Basic Language Developers Handbook
Ken Getz/Mike Gilbert
Sybex
ISBN: 0-8721-2162-4

This was published a couple of years back but may still be in print, if not it's
worth trying to get a "pre-owned" version through Amazon etc.

HTH + Cheers - Peter


"Barry" <barry.morenospam@virgin.net>, said:

>Can anyone recommend any good websites or books regarding learning VBA?
>
>
>Thanks in advance
>
>Barry
>

Howard
Sun Jul 04 05:15:19 CDT 2004

Better would be the VBA Developer's Handbook (ISBN 0782129781). See the
description at www.developershandbook.com.
The book is not for beginners, but should be in one's library.
--
http://www.standards.com/; See Howard Kaikow's web site.
"Peter Hewett" <nospam@xtra.co.nz> wrote in message
news:2pdee0dunfjt42lh7bc8abgg53c163d9c9@4ax.com...
> Hi Barry
>
> In addition to Howard's suggestions, there's these:
>
>
> http://www.computorcompanion.com/LPMArticle.asp?ID=22
> Part 1: Learn to create professional looking forms in Word.
> by Dian Chapman
> [Copyright (c) Logical Expressions, Inc.]
> http://www.computorcompanion.com/LPMArticle.asp?ID=46
> Part 2: Add Automation to your Word forms.
> by Dian Chapman
> [Copyright (c) Logical Expressions, Inc.]
>
> http://www.computorcompanion.com/LPMArticle.asp?ID=119
> Part 3: Learn more VBA (macros) to automate your forms.
> by Dian Chapman
> [Copyright (c) Logical Expressions, Inc.]
>
> http://www.computorcompanion.com/LPMArticle.asp?ID=127
> Part 4: Lean how to use dialog boxes in your Word forms.
> by Dian Chapman
> [Copyright (c) Logical Expressions, Inc.]
>
> http://www.computorcompanion.com/LPMArticle.asp?ID=136
> Part 5: Connect your AutoForm to a database to save input time and keep
> better records!
> by Dian Chapman
> [Copyright (c) Logical Expressions, Inc.]
>
> and of course:
>
> 1. Make sure you have the Word VBA online help installed, if not - Do it
now!
> 2. Make use of and familiarise yourself with the VBA IDEs Object Browser
(F2)
> 3. Use the MVP website: http://word.mvps.org/index.html
> 4. Use the Google News Group search feature
>
> The only book on VBA I'd ever recommend is:
>
> Visual Basic Language Developers Handbook
> Ken Getz/Mike Gilbert
> Sybex
> ISBN: 0-8721-2162-4
>
> This was published a couple of years back but may still be in print, if
not it's
> worth trying to get a "pre-owned" version through Amazon etc.
>
> HTH + Cheers - Peter
>
>
> "Barry" <barry.morenospam@virgin.net>, said:
>
> >Can anyone recommend any good websites or books regarding learning VBA?
> >
> >
> >Thanks in advance
> >
> >Barry
> >
>

Peter
Mon Jul 05 01:29:01 CDT 2004

Hi Howard Kaikow

I actually have any earlier version of this manual on me "archived" bookshelf, at the time
I paid almost 3 times it's US List price to purchase this manual in New Zealand. But at
the time it was worth it. I replaced it a few years back with the manual I recommended
which I've had no problems with in conjunction with VBA.

But having said that, I've not looked at the superseded VBA manual, as I've not seen it
here.

But Ken Getz and Mike Gilbert are to be highly recommended to all.

Cheers - Peter


"Howard Kaikow" <kaikow@standards.com>, said:

>Better would be the VBA Developer's Handbook (ISBN 0782129781). See the
>description at www.developershandbook.com.
>The book is not for beginners, but should be in one's library.

HTH + Cheers - Peter