Excel Programming by Ethan Thomas
Author:Ethan Thomas
Language: eng
Format: epub
Publisher: arestehcd
Chapter 3: Workbooks and Worksheets
In Chapter 3, we'll be exploring how to work with workbooks and worksheets in VBA code. Specifically, we'll be covering the following topics:
Opening and closing workbooks: We'll explore how to open and close Excel workbooks using VBA code, and how to specify file paths, file types, and other options.
Referencing workbooks and worksheets: We'll look at the various ways to reference workbooks and worksheets in VBA code, including by name, index, and object variable.
Navigating worksheets: We'll cover how to navigate through worksheets using VBA code, including selecting cells, ranges, and tables, and how to work with different types of cell data.
Modifying worksheets: We'll explore how to modify worksheets using VBA code, including how to add, delete, and move worksheets, as well as how to modify formatting, styles, and other worksheet properties.
Protecting and unprotecting worksheets: We'll look at how to protect and unprotect worksheets in VBA code, including how to specify passwords, allow specific users or groups to modify worksheets, and how to handle errors.
Saving and sharing workbooks: We'll cover how to save workbooks using VBA code, including how to specify file types, file names, and file locations, as well as how to share workbooks and protect sensitive data.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Ajax | Assembly Language Programming |
Borland Delphi | C & C++ |
C# | CSS |
Compiler Design | Compilers |
DHTML | Debugging |
Delphi | Fortran |
Java | Lisp |
Perl | Prolog |
Python | RPG |
Ruby | Swift |
Visual Basic | XHTML |
XML | XSL |
Deep Learning with Python by François Chollet(11924)
Hello! Python by Anthony Briggs(9389)
OCA Java SE 8 Programmer I Certification Guide by Mala Gupta(9354)
The Mikado Method by Ola Ellnestam Daniel Brolund(9321)
Dependency Injection in .NET by Mark Seemann(8867)
Algorithms of the Intelligent Web by Haralambos Marmanis;Dmitry Babenko(7862)
Test-Driven iOS Development with Swift 4 by Dominik Hauser(7354)
Grails in Action by Glen Smith Peter Ledbrook(7306)
The Well-Grounded Java Developer by Benjamin J. Evans Martijn Verburg(7130)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(5969)
Kotlin in Action by Dmitry Jemerov(4654)
Practical Vim (for Kathryn Amaral) by Drew Neil(3734)
Cracking the GRE Premium Edition with 6 Practice Tests, 2015 (Graduate School Test Preparation) by Princeton Review(3602)
Linux Device Driver Development Cookbook by Rodolfo Giometti(3455)
Learn Windows PowerShell in a Month of Lunches by Don Jones(3253)
Learning Java by Patrick Niemeyer & Daniel Leuck(2875)
Becoming a Dynamics 365 Finance and Supply Chain Solution Architect by Brent Dawson(2860)
Learning React: Functional Web Development with React and Redux by Banks Alex & Porcello Eve(2847)
Microservices with Go by Alexander Shuiskov(2655)