I have been looking for VBA reference books for Office97
with no luck. I have found a set of books at the Quantum
Books site but it is Microsoft  Office 2000 Visual Basic.
It includes "The set comprises language references for
Microsoft Access, Excel, Word, PowerPoint, FrontPage,
Office Web Components, Office Web Server, and Outlook,
plus a libraries reference for Microsoft Visual Basic for
Applications(VBA)".

My question is will these be useful for a Office97 user,
or are the difference to great between 97 and 2000.

Thanks Kevin

Hi Kevin,

The books likely point out "new" features and parts of the object model in
Office 2000. The one area where they may be weak is in dealing with problems
that were "fixed" by the new features but can be worked around in Office 97.
(No, I can't say what these are, just know that there were some.)

You may want to look on eBay and at Book Warehouse, etc. I put together a
page listing book comments made in the Word newsgroups at <URL:
http://www.addbalance.com/word/wordbooks.htm>. If you live in the USA you
may want to check your local public library, too. These books are expensive
and you may want to look at them before you buy. The library should be able
to get any book for you through inter-library loan.

I know that I liked Microsoft's Step-by-Step book on Office 2000 VBA. Hope
this helps,
--
Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://www.addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://www.addbalance.com/usersguide/index.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
 --------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

Are you looking at the Office 2000 Visual Basic for Applications series?

There was an earlier Office 97 VBA Programmer's guide that wasn't nearly as
well organized/laid out/written and had errors in some of the example code.
I imagine you could find it on Ebay or the like, but who'd want to? <g>

The O2000 version seems to do a pretty good job of explaining what's new to
Office 2000 and won't work in 97.

--
Steve Rindsberg, PowerPoint MVP
Got a PowerPoint wish/suggestion/beef?

Get the PPT FAQs at http://www.rdpslides.com/pptfaq/
RnR PPTools - http://www.rdpslides.com/pptools/
------

Try:  http://www.halfpricecomputerbooks.com/
They seem to carry a lot of the prior editions of books and the price is
right.

See the list of Word VBA books at my URL below.

--
Please post your response to the newsgroup. Do not email me a copy of the
message.

http://www.standards.com/ipusers/standards; Programming and support for
Word macros, including converting from WordBasic to VBA; Technical
reviewing; Standards; Product functional/design/specifications
------------------------------------------------

I work large models in both Excel97 and 2000 and have
found tons of undocumented differences between the two
that are a constant source of agony when writing VBA code.
Used books are the only way to go for xl97 right now. As
to the differences, these books only talk about the
different features not at all about how the same line of
code works (or doesn't work) in the two versions (and even
more nightmares when using Excel 2002). It's a trial by
error (or is it fire?) sort of thing you have to go
through. I always use the lowest common denominator of
features but even that doesn't guarantee that the same
code works in all versions.

Deb