Below is a list of Matthew's major publications. Hover the mouse pointer over a book title to see more
information about the book.
-
Teach Yourself Excel 2000 Programming With VBA in 21 Days (4th Ed.), Sole Author, 1999, Sams
|
|
ISBN: 0-672-31543-2; 1,144 pages, 4th Edition.
Foreign Language Versions: Russian
This book presumes the reader already has some experience using Excel, but no
experience programming. Explains programming in Visual Basic from the ground up,
then explains how to manipulate objects in Excel to automate various activities.
From the back cover: "Get expert tips from a leading authority on how to program Excel
2000 for the corporate environment."
|
-
Teach Yourself Visual Basic for Applications 5 in 21 Days (3rd Edition), Sole Author, 1997, Sams
|
|
|
ISBN: 0-672-31016-3; 1,214 pages, 3rd Edition.
Foreign Language Versions: Chinese, Korean(?)
This edition covers more of MS Office than just Excel. It first explains
Visual Basic programming from the ground up, then explains how to manipulate objects in
Excel, Word, and Access.
From the back cover: "Discover how to use VBA to control several different applications
from the same macro program."
|
-
Using Access 97, Contributing Author, 1997, Que
|
ISBN: 0-7879-0916-3; 1,284 pages.
This book covers all aspects of using MS Access 97. Matthew contributed a total of 20
chapters to this book, on beginning topics such as "Navigating Within Access",
"Working with Access Databases and Tables", and "Using Query by Example" to more
advanced topics such as "Using 32-bit OLE Components", "Using Access with Excel",
"Using Access with Word", and "Writing Visual Basic for Applications Code".
|
-
Database Developer's Guide with Visual Basic 5, Contributing Author, 1997, Sams
Unfortunately, Matthew no longer has an author copy of this particular book.
Like Database Developer's Guide for VB 4, this book covers all aspects of using
Visual Basic to control the MS Jet Database Engine to create various types of database
applications.
Matthew contributed a total of 10 chapters to this book, on intermediate to advanced
topics such as "Using Visual Basic's Data Control", "Connecting to Other Desktop Database
Tables", "Designing a Decision-Support Front-End", "Extending Your Use of the Data
Access Object", and "Using OLE Automation with Productivity Applications".
|
-
Database Developer's Guide with Visual Basic 4, Contributing Author, 1996, Sams
|
ISBN: 0-672-30652-2; 1,088 pages.
This book covers all aspects of using Visual Basic to control the MS Jet Database
Engine to create various types of database applications.
Matthew contributed a total of 10 chapters to this book, on intermediate to advanced
topics such as "Using Visual Basic's Data Control", "Connecting to Other Desktop Database
Tables", "Designing a Decision-Support Front-End", "Extending Your Use of the Data
Access Object", and "Using OLE Automation with Productivity Applications".
|
-
Teach Yourself Excel Programming With VBA in 21 Days, 2nd Ed., Sole Author, 1995, Sams
|
|
ISBN: 0-672-30782-0; 962 pages, 2nd Edition.
Foreign Language Versions: German
It's a special honor to have a technical book translated into German, as reference
books in the European market are extremely expensive, and customers are correspondingly
picky about the quality of the books.
|
-
Using Access 95, Contributing Author, 1995, Que
|
ISBN: 0-7897-0184-7; 1,290 pages.
This book covers all aspects of using MS Access 95. Matthew contributed a total of 10
chapters to this book, on beginning and intermediate topics such as "Navigating Within
Access", "Working with Access Databases and Tables", "Entering, Editing, and
Validating Data in Tables", "Creating and Using Forms", "Designing Custom Multitable
Forms", and "Preparing Advanced Reports".
|
-
Teach Yourself Visual Basic for Applications in 21 Days, Sole Author, 1994, Sams
|
|
ISBN: 0-672-30447-3; 909 pages, 1st Edition.
Foreign Language Versions: Chinese
From back cover: "This book presents Visual Basic for Applications programming
techniques in a logical and easy-to-learn sequence, beginning with simple concepts
and moving to more advanced material." Intended for readers with intermediate to advanced
knowledge of Windows and a Visual Basic for Applications (VBA) enabled program -
such as MS Excel or MS Word - but who have no programming experience or knowledge.
|
-
Unveiling Windows 95, Co-Author, 1994, Que
|
|
|
ISBN: 0-7897-0061-1; 909 pages.
Foreign Language Versions: Japanese, Portuguese
This book takes an introductory look at the then-upcoming Windows 95 operating system.
Written from beta versions of Windows 95, and published a few months
before Windows 95 was released.
Matthew contributed significantly to this book, writing chapters on connecting to
the Internet, installing/upgrading Windows 95, impact on existing/older programs,
gaming and multi-media features of Windows 95, and the architecture of Windows 95.
|
-
Using Paradox 5 for Windows, Contributing Author, 1994, Que
|
ISBN: 1-56529-758-x; 1,200 pages.
Matthew contributed a total of 4 chapters to this book, on the topics
"Designing a Paradox for Windows Database", "Customizing Data Entry Forms",
"Validating Data Entry", and "Creating a Mailing List".
|
-
Excel 5 Professional Techniques, Contributing Author, 1994, Que
|
|
ISBN: 1-56529-325-8; 781 pages.
Foreign Language Versions: Portuguese
This book covers advanced Excel topics. Matthew contributed a total of 4 chapters to this book on
topics such as data exchange, data file formats, and other issues related to using or exchanging
data among applications such as databases, word processors, and spreadsheet programs.
|
-
The Disk Compression Book, Sole Author, 1993, Sams
|
ISBN: 1-56529-288-X; 338 pages.
This book was Matthew's first solo creation. This book, intended for readers with beginning to
intermediate computer experience, explains what disk compression is, how it works, how to use it
effectively, and provides how-to directions for using the two most popular disk-compression products
available at the time of publication: Stacker, by STAC Electronics, and DoubleSpace, which was
provided as part of MS-DOS 6 and Windows 95. This book provides step-by-step instructions to
install, configure, and use either of these two disk compression packages.
The book includes many helpful tips, cautions, and troubleshooting hints.
|
-
Using Excel 5 for Windows, Contributing Author, 1993, Que
|
ISBN: 1-56529-459-9; 1,276 pages.
Matthew contributed 4 chapters on VBA programming to this comprehensive power-user's guide to
MS Excel. Matthew's contributions related to data exchange, data file formats, and other issues
related to using or exchanging data among applications such as databases, word processors, and
spreadsheet programs.
|
-
Using Word 6 for Windows, Contributing Author, 1993, Que
|
ISBN: 1-56529-469-6; 1,212 pages.
Matthew contributed 4 chapters to this comprehensive guide to using MS Word.
|
-
Using MS-DOS 6, Contributing Author, 1993, Que
|
|
ISBN: 1-56529-020-8; 1,172 pages.
Foreign Language Versions: Spanish
In addition to contributing several chapters to this comprehensive MS-DOS reference,
Matthew also performed technical editing for several chapters written by others.
The cover of the Spanish-language version shows DOS 6.2 because it was published about
a year after the English version, and DOS was up to 6.2 because of maintenance releases.
|
-
Using Paradox 4.5 for DOS, Contributing Author, 1993, Que
|
ISBN: 1-56529-554-4; 799 pages.
Matthew contributed 4 chapters to this book, all having to do with database programming in
Paradox: "Using the Applications Workshop", "An Overview of the Paradox Application Language",
"Using the Paradox Application Language", and "Using the Script Editor and PAL Debugger".
|
-
Using FileMaker Pro 2.0 for Windows, Co-author, 1992, Que
|
ISBN: 1-56529-066-6; 668 pages.
FileMaker Pro 2.0 was the first Windows version of this well-known MacIntosh
database product. Already establishing a reputation as a database expert, Matthew
was asked by the Que editors to "translate" the existing book covering the Mac version
of FileMaker Pro 2.0 for the Windows version of the program.
|
-
The Paradox 4.0 Developer's Guide, Contributing Author, 1992, Que
|
ISBN: 0-88022-705-2; 978 pages.
Matthew contributed 6 chapters to this book: "Designing Forms for Applications",
"Errors and Error-Handling", "Resource Management", "Advanced Queries",
"Executing DOS Commands and Programs", and "Data-Transfer Strategies".
|
-
Using Paradox 4 for DOS, Contributing Author, 1992, Que
|
ISBN: 0-88022-822-9; 1074 pages.
Matthew contributed 5 chapters to this user's guide for Paradox: "Using the
Applications Workshop" (a code generator utility), "An Overview of the Paradox Application Language",
"Using the Paradox Application Language", "Using the Script Editor and PAL Debugger",
"PAL Command and Function Reference", and "PAL Color Palette Codes".
|
