WILEY

KNOWLEDGE FOR GENERATIONS

WILEY - KNOWLEDGE FOR GENERATIONS

United States Change Location

cart.gif CART |  MY ACCOUNT |  CONTACT US |  HELP    
Cover image for product 0764544012
Excel 2000 VBA: Programmers Reference
ISBN: 978-0-7645-4401-9
Paperback
744 pages
June 1999
US $39.99 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

This is a Print-on-Demand title. It will be printed specifically to fill your order. Please allow an additional 1-2 days delivery time for paperbacks, and 3-5 days for hardcovers. The book is not returnable.
  • Description
  • Table of Contents
  • Author Information
  • Errata
  • Download

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.

ChapterPageDetailsDatePrint Run
0 Index entry errors

The index errors reported in the above erratum have been corrected for the second edition of the book published in January 2000.

27-Sep-00 1
56 Page 56 - Code correction

The code at the top of page 56, GetFileName(), should read:

Sub GetFileName()
Dim BackSlash As Integer, Point As Integer
Dim FilePath As String, Filename As String
Dim i As Integer

FilePath = ActiveWorkbook.Fullname
For i = Len(FilePath) To 1 Step -1
If Mid$(FilePath,i,1) = "." Then
Point = i
Exit For
End If
Next i

If Point=0 Then Point = Len(FilePath) + 1

For i = Point - 1 To 1 Step -1
If Mid$(FilePath, i, 1) = "\" Then
BackSlash = i
Exit For
End If
Next i

Filename = Mid$(FilePath, BackSlash + 1, Point - BackSlash - 1)
MsgBox Filename
End Sub

Thanks to John Mitchell.

26-Mar-01 1
697 Index entry errors

Unfortunately an error in the automatic production of the Index from the indexed chapter files was not detected until after publication. As a result some index entries have page numbers 120 too low, either instead of, or, as well as, the correct page numbers.

If a page number in the index is wrong, then correct it by adding 120.

More specifically:
1. All page numbers for entries under, "Command Bars" and, "Menus" should be raised by 120.
2. Page numbers for entries under "Toolbars" in the range 50-100 should be raised by 120. Higher and lower page numbers remain unchanged.
3. Where two page numbers differing by 120 are listed for the same index entry, the higher member of the pair is correct, while the lower should be disregarded.

All the errors in the index fall in one of the three categories listed above.

Wrox Press would like to apologise for any inconvenience experienced as a result of this error.

27-Sep-00 1