Download
vba com and osi n.
Skip this Video
Loading SlideShow in 5 Seconds..
VBA, COM and OSI: PowerPoint Presentation
Download Presentation
VBA, COM and OSI:

VBA, COM and OSI:

549 Vues Download Presentation
Télécharger la présentation

VBA, COM and OSI:

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. VBA, COM and OSI: Building the Digital Nervous System Neil Charney Senior Product Manager Microsoft Corporation

  2. Partners Great products Microsoft Is About Two Things • Outstanding products • Outstanding partners

  3. Leveraging Partnerships Microsoft Microsoft & OSI Microsoft Partner Microsoft/OSI Partner Community Community Standards Standards Marketing Marketing Tools Tools R&D R&D

  4. Web Today’s World:Complex Pieces - No Integration Core IT Infrastructure Enterprise Data Legacy Systems Remote Systems Server “Extranet” Customer Access Windows 95 Office 97 Windows 95 Office 97 Multiple Applications, Multiple Data Stores

  5. Reacting to unplannedevents Executing on plannedevents Competitive advantage Digital Nervous System

  6. Up-to-datepersonal computer Internet, Intranetconnections Commonproductivitysuite Building ASuccessfulNervousSystem Rich, reliableelectronic mail Integrated LOBapplications

  7. Digital Nervous System Building Blocks • Up-to-date PC • Common productivity suite • Rich, reliable messaging • Internet connections • Line-of-business apps that work together

  8. Visual Studio 97 • Comprehensive • Scalable • Open

  9. Visual Basic for Applications Bringing the power of Visual Basic to Applications

  10. Visual Basic for Applications • Professional development environment • Access to application functionality • Tight integration with user and application events (open, close, click, etc.) • Support for ActiveX components • Fast performance - Up to 200X faster

  11. 1997 1995 1993 Office 97 1987 Microsoft Access 95 Microsoft Excel 5.0 & Project 4.0 Beyond Macro Processing VBA Milestones

  12. Demo: Visual Basic for Applications Microsoft Excel

  13. Office 97 TCO Study • Study of Office 97 Early Adopters • Over 300,000 desktops • VBA development generated 50% cost savings • Leveraged existing developer resources • Customized and automated business processes • 75% planning solutions with Office and VBA Source: Giga Group 1997

  14. 1 Print mainframe report u 2 Key data Into other u spreadsheet 3 Perform data analysis u 4 Chart data in u spreadsheet 5 Chart data in other u graphics package 6 Add comments u CIGNA P&C: Past Process Day 1 Day 2 Day 3

  15. Demo: Visual Basic for Applications Cigna P&C

  16. >100 Companies in 23 Industries VBA Licensing 1997 29 Shipping Products 1995 1993 Office 97 1987 Microsoft Access 95 Microsoft Excel 5.0 & Project 4.0 Beyond Macro Processing VBA Milestones

  17. Horizontal Components Broad Industry Support for VBA Engineering Manufacturing Development Tools Data Analysis CAD/CAM Project Management Simulation Vertical Components Help Desk, Document Management, Corporate Applications Accounting, Customer Management, ERP, Data Warehousing Microsoft Office

  18. VBA and COM: Building the Digital Nervous System • Integrates multiple line of business applications • Customizes off-the-shelf software to respond to changes in requirements • Leverages existing data, equipment, infrastructure and skills

  19. Demo: Visual Basic for Applications Integrating VBA enabled applications

  20. Manufacturing Competitive advantage Digital Nervous System Reacting to unplannedevents Executing on plannedevents Competitor Initiatives Variable Configurations New Gov’t Regulations Smaller Batch Sizes • High Productivity • High Quality • Low Cost • Flexibility • Integration • Quick Reaction

  21. OSI Microsoft Office Systems Modeling Rockwell Intellution Iconics Nemasoft PID Great Plains/IControl Autodesk Visio Parametric A Manufacturing DNS World Analysis Simulation HMI/Control MRP/ Finance Product Design Hardware/ Shop Floor

  22. PI-ProcessBook/VBAProduct Demo Alton Loe, OSI Software

  23. Office 97 Developer EditionEverything for building and distributing solutions with Office 97 • Office Pro Plus • Microsoft Access run time, Microsoft Access, Visual SourceSafe™ integration, Setup Wizard, ActiveX Controls, Jet Replication Tools • Printed documentation • MSDN Office Developer Sampler

  24. Resources And Training • Office Developer Forum • http://www.microsoft.com/officedev/ • White papers, sample code, articles, events • Developer conferences • VBiTs, TechEd • VBA Solutions Conference (http://www.vbaconference.com) • Publications • VBPJ , Microsoft Office & VBA Developer

  25. Mark Your Calendars! New Orleans, LouisianaJune 1-5, 1998http://www.microsoft.com/events/teched • Strong solutions focus • Many Office/VBA sessions • Demo area, peer talk, expo hall, more

  26. Mark Your Calendars! Office and VBA Solutions Conference and Exposition Informant Communications & Microsoft London, England July 12-15, 1998 AND…October, 1998, Los Angeles • Office development sessions • VBA ISV sessions • Expo hall and more