VBA, COM and OSI: - PowerPoint PPT Presentation

Vba com and osi l.jpg
Download
1 / 27

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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

VBA, COM and OSI:

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Vba com and osi l.jpg

VBA, COM and OSI:

Building the Digital Nervous System

Neil Charney

Senior Product Manager

Microsoft Corporation


Microsoft is about two things l.jpg

Partners

Great products

Microsoft Is About Two Things

  • Outstanding products

  • Outstanding partners


Leveraging partnerships l.jpg

Leveraging Partnerships

Microsoft

Microsoft & OSI

Microsoft

Partner

Microsoft/OSI

Partner

Community

Community

Standards

Standards

Marketing

Marketing

Tools

Tools

R&D

R&D


Today s world complex pieces no integration l.jpg

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


Slide5 l.jpg

Reacting to unplannedevents

Executing on plannedevents

Competitive advantage

Digital

Nervous

System


Slide6 l.jpg

Up-to-datepersonal computer

Internet, Intranetconnections

Commonproductivitysuite

Building ASuccessfulNervousSystem

Rich, reliableelectronic mail

Integrated LOBapplications


Digital nervous system building blocks l.jpg

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 l.jpg

Visual Studio 97

  • Comprehensive

  • Scalable

  • Open


Visual basic for applications l.jpg

Visual Basic for Applications

Bringing the power of Visual Basic to Applications


Visual basic for applications10 l.jpg

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


Slide11 l.jpg

1997

1995

1993

Office 97

1987

Microsoft Access 95

Microsoft Excel 5.0 & Project 4.0

Beyond Macro Processing

VBA Milestones


Microsoft excel l.jpg

Demo:

Visual Basic for Applications

Microsoft Excel


Office 97 tco study l.jpg

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


Slide14 l.jpg

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


Cigna p c l.jpg

Demo:

Visual Basic for Applications

Cigna P&C


Slide16 l.jpg

>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


Broad industry support for vba l.jpg

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 l.jpg

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


Integrating vba enabled applications l.jpg

Demo:

Visual Basic for Applications

Integrating VBA enabled applications


Slide20 l.jpg

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


A manufacturing dns world l.jpg

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 vba product demo l.jpg

PI-ProcessBook/VBAProduct Demo

Alton Loe, OSI Software


Office 97 developer edition everything for building and distributing solutions with office 97 l.jpg

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 l.jpg

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 l.jpg

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 calendars26 l.jpg

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


  • Login