110 likes | 238 Vues
Join Neal Saito and Gary Marchiny in exploring the AMF approach to enhance your MS Office productivity. This session covers common MS Office tasks, a powerful VBA library tailored for AMF, utilities for Excel and Word, and guidance on developing your own AMF-based tools. Learn how to efficiently manage and view artifacts while assessing data within the AMF architecture. Enhance your skills in creating reusable business objects and integrating data layers for streamlined workflows. Discover expert tips and access valuable resources to elevate your MS Office experience.
E N D
Accelerating MS Office Work with AMF Neal Saito & Gary Marchiny
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
Common IV&V MS Office Tasks • Viewing Artifacts • Assessing Artifacts • Converting Artifacts
AMF VBA Library for MS Office S:\IV&V OFFICE\CD\Initiatives\AMF\Products\AMF Libraries\VBA (MS Office)
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.
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
User Interface Layer • AMF Excel Utilities • AMF VBA Utilities • AMF Word Utilities • AMF SQL Script Utilities • Develop your own
Questions? For more information on the AMF: Don Kranz – Donald.E.Kranz@ivv.nasa.gov Gary Marchiny – Gary.S.Marchiny@ivv.nasa.gov