1 / 10

Accelerating MS Office Work with AMF

Learn how to accelerate common MS Office tasks using AMF VBA Library and create custom utilities for Excel, Word, and SQL. Explore the IV&V MS Office Tasks, Data Management Architecture, and User Interface Layer. Contact Don Kranz or Gary Marchiny for more information.

rinaldi
Download Presentation

Accelerating MS Office Work with AMF

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. Accelerating MS Office Work with AMF Neal Saito & Gary Marchiny

  2. Agenda • Common MS Office Tasks • MS Office AMF VBA Library • MS Office AMF-Based Utilities • AMF Excel Utilities • AMF Word Utilities • Create your own AMF utilities

  3. Common IV&V MS Office Tasks • Viewing Artifacts • Assessing Artifacts • Converting Artifacts

  4. AMF VBA Library for MS Office S:\IV&V OFFICE\CD\Initiatives\AMF\Products\AMF Libraries\VBA (MS Office)

  5. IVVO Data Management Architecture

  6. Business Layer • The VBA Business Layer is reused by ALL MS Office products. There is only one set of business objects based on the AMF architecture.

  7. Data Layer(s) • Each data source and/or target requires a data layer. Excel • amfExcelProjectDataLayer • amfExcelArtifactDataLayer • amfExcelAssessmenttDataLayer • amfExcelActionDataLayer SQLScript • amfSQLScriptProjectDataLayer • amfSQLScriptArtifactDataLayer • amfSQLScriptAssessmenttDataLayer • amfSQLScriptActionDataLayer Word • amfWordProjectDataLayer • amfWordArtifactDataLayer • amfWordAssessmenttDataLayer • amfWordActionDataLayer SQL • amfSQLProjectDataLayer • amfSQLArtifactDataLayer • amfSQLAssessmenttDataLayer • amfSQLActionDataLayer

  8. User Interface Layer • AMF Excel Utilities • AMF VBA Utilities • AMF Word Utilities • AMF SQL Script Utilities • Develop your own

  9. UTILITIES DEMO

  10. Questions? For more information on the AMF: Don Kranz – Donald.E.Kranz@ivv.nasa.gov Gary Marchiny – Gary.S.Marchiny@ivv.nasa.gov

More Related