1 / 16

Introduction to Visual Basic for Applications

Introduction to Visual Basic for Applications. LT Craig Maxey. Context Analyst’s are constantly tasked with an excess of work. Programming capabilities introduced to the analyst community will elevate the efficacy of their work. Purpose

satin
Download Presentation

Introduction to Visual Basic for Applications

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to Visual Basic for Applications LT Craig Maxey

  2. Context • Analyst’s are constantly tasked with an excess of work. Programming capabilities introduced to the analyst community will elevate the efficacy of their work. • Purpose • Introduce analysts to the capabilities and functionality of a powerful programming platform resident on each of their machines • Outcome • Will provide analysts an overview of capabilities if they choose to increase their knowledge of Excel VBA FOR OFFICIAL USE ONLY

  3. Overview • Introduction • Capabilities • Macro’s • Integrated Development Environment • Data Types • Range Objects • Iterative Programming • Practice

  4. Capabilities • Applications • HEDIS Opportunity Tool • Data Manipulation • PEB Data Manipulation • Fit To Fill Workflow • Data Cleanup • M2 Data cleanup

  5. ApplicationsHEDIS Opportunity Tool

  6. PEB Data Manipulation

  7. PEB Data Manipulation (Cont.)

  8. M2 Data Cleanup

  9. Macro’s

  10. Integrated Development Environment (IDE)/WorkFlow

  11. Programming Basics FOR OFFICIAL USE ONLY

  12. Data Types • Int - Integers • Double – Double Precision Floating Point • Range from -1.7E308 to 1.7E308 (That’s Big) • Strings – Text (These are objects, but we will worry about what that means later) • Booleans – T/F

  13. Range Object • Represents a contiguous area of cells in a spreadsheet • Range is the base object in Excel VBA Programming

  14. Iterative Programming • For Loop • Do Loop

  15. Summation Idea • Let’s Make a Calculator!!! • What do we need? • How do we return a value?

  16. Questions?

More Related