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

Loading in 2 Seconds...

play fullscreen
1 / 27

VBA, COM and OSI: - PowerPoint PPT Presentation


  • 483 Views
  • Uploaded on

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

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

PowerPoint Slideshow about 'VBA, COM and OSI:' - victoria


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

VBA, COM and OSI:

Building the Digital Nervous System

Neil Charney

Senior Product Manager

Microsoft Corporation

microsoft is about two things

Partners

Great products

Microsoft Is About Two Things
  • Outstanding products
  • Outstanding partners
leveraging partnerships
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

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

Reacting to unplannedevents

Executing on plannedevents

Competitive advantage

Digital

Nervous

System

slide6

Up-to-datepersonal computer

Internet, Intranetconnections

Commonproductivitysuite

Building ASuccessfulNervousSystem

Rich, reliableelectronic mail

Integrated LOBapplications

digital nervous system building blocks
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
Visual Studio 97
  • Comprehensive
  • Scalable
  • Open
visual basic for applications
Visual Basic for Applications

Bringing the power of Visual Basic to Applications

visual basic for applications10
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

1997

1995

1993

Office 97

1987

Microsoft Access 95

Microsoft Excel 5.0 & Project 4.0

Beyond Macro Processing

VBA Milestones

microsoft excel

Demo:

Visual Basic for Applications

Microsoft Excel

office 97 tco study
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

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

Demo:

Visual Basic for Applications

Cigna P&C

slide16

>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

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
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

Demo:

Visual Basic for Applications

Integrating VBA enabled applications

slide20

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

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

PI-ProcessBook/VBAProduct Demo

Alton Loe, OSI Software

office 97 developer edition everything for building and distributing solutions with office 97
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
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
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
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