Business Programming with Excel VBA

Information Systems

Microsoft Office

ISBN:

978-1-952023-18-7

Business Programming with Excel VBA

Matt Harris, PhD

With this resource, students gain fundamental Visual Basic for Applications (VBA) knowledge and skills, including the ability to automate their own work in Excel as well as design and program complete applications for others to use. Tackle the most difficult and complex Excel VBA programming tasks for data retrieval, presentation, and analysis.

Preview a Chapter

Request Access

Free instructor demo access to full resource

Plug-and-play solution for instant adoption

Lifetime access for students

Introduction Chapter 1: Getting Started – Learning About Macros Chapter 2: Recording and Editing Macros for Complex Tasks Chapter 3: Understanding Objects and Collections Chapter 4: Writing Simple Macro Procedures Chapter 5: Working with Ranges and Cells Chapter 6: Understanding Data Types, Variables, and Constants Chapter 7: Operators and Expressions Chapter 8: Built-In Functions in VBA and Excel Chapter 9: Using VBA Functions to Manipulate and Compare Strings Chapter 10: Formatting Data Values Chapter 11: Creating and Using Your Own Functions in VBA Chapter 12: Creating Excel User-Defined Functions Chapter 13: Making Decisions in VBA: Flow Control Chapter 14: Repeating Actions in VBA: Loops Chapter 15: Debugging and Testing VBA Code Chapter 16: Working with Excel's Built-In Objects and Collections Chapter 17: Working with Chart Objects Chapter 18: Using Excel's Built-In File Dialogs Chapter 19: Working With Pivot Tables Chapter 20: Advanced Topics for Variables, Constants, and Data-Types Chapter 21: Defensive Programming: Preventing Errors Before They Happen Chapter 22: Error Handling Chapter 23: Creating Libraries and Whole Programs: Modular Programming Techniques Chapter 24: Creating and Using Arrays Chapter 25: Sorting and Searching Arrays Chapter 26: Creating Custom Dialogs with User Forms Chapter 27: Creating Custom Ribbons for Your Workbooks Chapter 28: Importing Data From A Database Chapter 29: Using VBA to Control Internet Explorer Chapter 30: Automating Solver With VBA Chapter 31: Using the FollowHyperlink Method Chapter 32: Using Event Procedures Chapter 33: Creating, Deploying, and Controlling Add-Ins Chapter 34: Creating Your Own Data Types Chapter 35: Creating Your Own Classes and Collections Chapter 36: Managing Files and Reading & Writing Text Files with VBA Chapter 37: Working With Other Applications Chapter 38: Using VBA to Send E-Mail with MS Outlook and Google Mail Chapter 39: Using VBA to Control MS Word Chapter 40: Using VBA with Google Docs Chapter 41: Using VBA to Control MS PowerPoint

Request Free Access

Interested in using this resource in your course? Request free instructor access. Just tell us who you are and where you teach, and we’ll take care of the rest!

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Made by proffessors, for professors

Auto-Graded Assessments

Customize assessments or create new ones. Assessments are completed online within the text and instantly graded with detailed feedback.

LMS Integration

Access courseware with single sign-on convenience using our LMS integration tools. Assignments, exams, and grades are automatically synced.

Instructor Materials

Take advantage of study plans, PowerPoint presentations, and test banks so that courses require minimal start-up time.

Micro-Credentials & Certificates

Allow your students to earn achievements in the classroom. Keep them engaged using ready-made badges and certificates, or create your own.

AI Virtual Assistant

Our AI Virtual Assistant transforms how students engage with content, offering features like multilingual translation, question answering, progress assessment, and much more.