excel 2007This book “I Wish I Knew How to … Program Excel with Real Studio in Windows” goes into the numerous options of programming Excel.
 
This guide uses the power of Real Studio in conjunction with the power of Excel. The question is frequently asked ‘why not just create the program in Excel?’ The answer is confidentiality, security, and automation. It is relatively common knowledge that program created in Excel are not secure and can be easily modified to view the original formulas for calculating results – no matter how much protection has been placed in the original program.
 
The ‘I Wish I Knew’ series contains technical data and advice that makes sense and contains practical and numerous examples with explanations to allow you to ease into the steep programming curve. You can create Microsoft Excel applications today!
 
Click to download the Table Of Contents
 
There are over 8 chapters and contains over 190 pages with over 65 example programs. The book is a live document and will likely have updates in the future.
 
Examples include graphing, pivot tables, speaking in Excel, printing pages, saving Excel files to PDF, and more.  Many screenshots have been added to show the results of the code with a full index to help find topics quickly.The book is in PDF format with example chapter folders containing Xojo source code and running examples.
 
A version of Microsoft Office must be installed on a Windows computer for this to work.
 
This book can be purchased at Great White Software where many great Xojo and Real Studio resources are available.
 
ISBN: 978-0-9880947-0-3