Excel 2003 VBA Programmer's Reference

Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg, Brian Patterson (Contributions by)

ISBN: 978-0-7645-5660-9

Paperback

1176 pages

July 2004

Excel 2003 VBA Programmer's Reference (0764556606) cover image

This title is out-of-print and not currently available for purchase from this site.

< >

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

Chapter	Page	Details	Date
		Code Replacement / Errata Download The content for this title has been posted and may be accessed via: http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764556606,descCd-download_code.html	03/13/2006
	Code Download	Problems with code downloads If you are experiencing problems with the code for this book, you can try the code downloads for the 2002 version of this book, which is located here.	12/17/04
	38	Missing Verb in Sentence The text in first gray box reads: "Note that subroutines and functions can both accept arguments. However, you cannot subroutine with input parameters directly by pressing F5." The second sentence is missing a verb between "cannot" and "subroutine"	5/2/05
	52	Duplicate Code Code Lines "i = i + 1" at the very bottom of the page. The code is meant to simulate a password login with only 3 attempts to enter the correct password. The 3 attempts only work if the mentioned line is only used once, and not twice as dictated in the book.	7/20/05
9	179	Error in Code Block In the code block at the end of the page, the following text is missing on line 13: �Select Case Data(1, 3)�	10/10/05
	207	Error in Text second shaded passage: If Connection.State = ObjectStateEnum.adStateOpen) Then objConn.Close. Should be: If (Connection.State = ObjectStateEnum.adStateOpen) Then Connection.Close	03/22/07
	211	Error in Text Final paragraph on page 211 starts: "Line declares the WithEvents statement". Should be: "Line 2 declares the WithEvents statement"	11/16/05
	446	Error in Code Box at Code in the grey box at the bottom of page 446 should be corrected as follows: Public Sub AddNewData() Dim lRows As Long With Range("DataBase") lRows = .Rows.Count + 1 Range("Input").Copy Destination:=.Cells(lRows, 1) .Resize(lRows).Name = "Database" End With End Sub	6/1/05
Appendix		Missing Appendix for download Please go to the download page to download the missing appendix.	6/1/05
	Back Cover	This book does not cover VB.Net with Excel On the back cover it mentions that included in this book's contents you will learn how to use VB.Net with Excel. This book does not cover that.	3/30/05
26		Updated Files for Chapter 26 Download updated code for Chapter 26 from the Download page.	3/10/06