Excel VBA for Physicists: A Primer

ISBN-13: 9781681744605 / Angielski / Miękka / 2016 / 91 str.

Bernard V. Liengme

Opis

This book is both an introduction and a demonstration of how Visual Basic for Applications (VBA) can greatly enhance Microsoft Excel(R) by giving users the ability to create their own functions within a worksheet and to create subroutines to perform repetitive actions. The book is written so readers are encouraged to experiment with VBA programming with examples using fairly simple physics or non-complicated mathematics such as root finding and numerical integration. Tested Excel(R) workbooks are available for each chapter and there is nothing to buy or install.

Spis treści

• Preface
• Acknowledgements
• Author biography
• Chapter 1. Introduction
• Chapter 2. Variables, Dim statements, and data types
• Chapter 3. Structured programming
• Chapter 4. The Excel object model
• Chapter 5. Working with add-ins
• Chapter 6. Numerical integration
• Chapter 7. Numerical methods for differential equations
• Chapter 8. Finding roots