Buch, Englisch, 789 Seiten, Paperback, Format (B × H): 178 mm x 254 mm, Gewicht: 15018 g
A Practical Real-World Guide
Buch, Englisch, 789 Seiten, Paperback, Format (B × H): 178 mm x 254 mm, Gewicht: 15018 g
ISBN: 978-1-4842-2204-1
Verlag: Apress
In this book, you will learn: - How to interact with key Excel objects, such as the application object, workbook object, and range object
- Methods for working with ranges in detail using code
- Usage of Excel as a database repository
- How to exchange data between Excel applications
- How to use the Windows API to expand the capabilities of Excel
- A step-by-step method for producing your own custom Excel ribbonWho This Book Is For:Developers and intermediate-to-advanced Excel users who want to dive deeper into the capabilities of Excel 2016 using code.
Zielgruppe
Professional/practitioner
Autoren/Hrsg.
Fachgebiete
- Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Programmier- und Skriptsprachen
- Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation Microsoft Excel
- Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Microsoft Programmierung
Weitere Infos & Material
Chapter 1: Understanding Visual Basic for Applications (VBA).- Chapter 2: Programming the Excel Application Object.- Chapter 3: Programming the Excel Workbook Object.- Chapter 4: Programming the Excel Worksheet Object.- Chapter 5: Programming the Excel Range Object.- Chapter 6: Special Range Object Properties and Methods.- Chapter 7: Using Excel as a Database Repository.- Chapter 8: Creating and Setting a Worksheet Database Class.- Chapter 9: Exchanging Data Between Excel Applications.- Chapter 10: Using the Windows API.- Chapter 11: Producing a Personal Ribbon using the RibbonEx Add-In.