Update-Program Excel 2016 with Xojo In Windows (3.3)

I Wish I Knew How To… Program Excel 2016 with Xojo on Windows has been updated to April 2017. There are 14 chapters and the book contains more than 300 pages with over 120 example programs.

Excel examples include graphing. pivot tables, speaking in Excel and more. For those who have purchased previous 3.x versions, this is a free update.

New to Version 3.3 – April 2017

  • Many thanks to Alberto De Poo for some editing suggestions
  • Clarification: Examples will work with Office 365, and almost no example will work in the reader (Chapter 5)
  • Excel Viewer will be retired in April 2018
  • Updated code in Example 2-3 to include Add and Visible to match the book
  • Changed Example 2-3 (page 21) description where the only open sheet is Sheet1 and not Sheet3
  • Page 22 has the text changed to show Sheet1 is open and not Sheet3
  • Page 53 (Example 3-15) changed data that is added to the second sheet
  • Changed Example 3-15 to allow the option of language-neutral selection of the pages using an integer value. Caution: An integer value of 2 will select the second sheet and “Sheet2” will select the correct sheet tab name, even if it is not the second sheet
  • Added alphabetical Excel sheet ordering in Example 3-26
  • Added example to place an Excel addin at runtime (Example Other-6)
  • Added change text colour example (Example 3-27)

This book is a PDF document and all examples include Xojo code. The Office plugin that accompanies Xojo is needed with this book. The Table of Contents has a listing of all examples in the book, and is on the authors website at http://scispec.ca , in the books header.

ISBN: 978-1-927924-15-0

This book can be purchased at http://xdevlibrary.com