280 likes | 929 Views
VBA, COM and OSI:. Building the Digital Nervous System. Neil Charney Senior Product Manager Microsoft Corporation . Partners. Great products. Microsoft Is About Two Things. Outstanding products Outstanding partners. Leveraging Partnerships. Microsoft. Microsoft & OSI. Microsoft
E N D
VBA, COM and OSI: Building the Digital Nervous System Neil Charney Senior Product Manager Microsoft Corporation
Partners Great products Microsoft Is About Two Things • Outstanding products • Outstanding partners
Leveraging Partnerships Microsoft Microsoft & OSI Microsoft Partner Microsoft/OSI Partner Community Community Standards Standards Marketing Marketing Tools Tools R&D R&D
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
Reacting to unplannedevents Executing on plannedevents Competitive advantage Digital Nervous System
Up-to-datepersonal computer Internet, Intranetconnections Commonproductivitysuite Building ASuccessfulNervousSystem Rich, reliableelectronic mail Integrated LOBapplications
Digital Nervous System Building Blocks • Up-to-date PC • Common productivity suite • Rich, reliable messaging • Internet connections • Line-of-business apps that work together
Visual Studio 97 • Comprehensive • Scalable • Open
Visual Basic for Applications Bringing the power of Visual Basic to Applications
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
1997 1995 1993 Office 97 1987 Microsoft Access 95 Microsoft Excel 5.0 & Project 4.0 Beyond Macro Processing VBA Milestones
Demo: Visual Basic for Applications Microsoft Excel
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
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
Demo: Visual Basic for Applications Cigna P&C
>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
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
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
Demo: Visual Basic for Applications Integrating VBA enabled applications
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
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
PI-ProcessBook/VBAProduct Demo Alton Loe, OSI Software
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
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
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
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