Errata: Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

Chris_010101

Chris_010101

Board Regular
Joined
Jul 24, 2017
Messages
191
Office Version
  1. 365
Platform
  1. Windows
Hello,

I've noticed two errors:

Introduction XXXV: the link for errata no longer works. It just links straight to a form to report, but does not list the errors.

not sure if this is actually one: chapter 1, page 9: Personal workbook is a .xlsb not .xlsm

Thanks
Chris
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
MrExcel said:
Thanks for reporting this. The book lists this link: Microsoftpressstore.com/ExcelVBAMacros365/errata
When I enter that link, it redirects here: Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) | Microsoft Press Store

This book just started shipping a few months ago. It is possible that yours is the first being reported. Thanks for pointing this out.
Click to expand...
Yes, apologies, it links straight to where you said.

Just wanted to say, I'm only at chapter 1 page 15 and I've already learned a number of tips and tricks which will make my day a great deal easier.

This is a good book, thanks!
 
Chapter 1: Page 16

A part of the downloaded companion content does not match the book.

The instructions on page 16 ask you to select invoice.txt but invoice1.txt is the file which matches the image in the book.

I got around this by swapping the names of invoice.txt and invoice1.txt.

Regards
Chris
 
Later instructions on page 20 ask you to rename invoice.txt to invoice1.txt and rename invoice2.txt to invoice.txt. However, there is already an invoice1.txt in the download meaning you would overwrite something you need.

The fix in the download on the Microsoft website would be:

1. Delete invoice.txt (this is the same as invoice2.txt)
2. Rename invoice1.txt to invoice.txt

This would mean that you could rename invoice.txt to invoice1.txt, per instructions on page 20 without overwriting anything.

I've done the above and the instructions in the book now match the download.

Regards
Chris
 
Last edited:
Chapter 1: page 23

Text refers you to check in cell E19 for a green warning triangle. This is actually in cell E23, F23 or G23.

The macro also totalled rows 14 to 22, not 10 to 18 as suggested in the book.

1666554534073.png


Regards
Chris
 
Last edited:
@Chris_010101
There is no need for a separate thread for each one so I have combined them. In fact, in the link that has already been provided above, there is link to where you can submit errata:

1666602159826.png
 
You must log in or register to reply here.

Forum statistics

Threads
1,216,499
Messages
6,131,012
Members
449,613
Latest member
MedDash99

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top