Excel as User Interface for IBM i

2015-07-21, Meetings, Richard DeVost,

As companies everywhere realize that the effective use of information can provide them with strategic advantages over their competitors, access to this information is being required in new scenarios. Many organizations now need the ability to use information seamlessly in all types of documents.

Meanwhile, data access technologies have rapidly evolved to provide access to centralized data in these new scenarios. ADO is designed for high-performance data access in all development scenarios, regardless of the data source, the programming language, or the applications physical architecture.

And since the Microsoft Excel spreadsheet is one of the most pervasive tools on the planet, programming applications in Excel using VBA and ADO is a natural fit. Come to this presentation and let me show you how.


Michael Daly is a Sr. Consultant/Developer with KS2 Technologies, Inc. Using the latest Rational development tools from IBM, Michael is responsible for design and development of software solutions for clients in many varied industries. Web design, Java, and good old-fashioned RPG are his strong suits.

A 25-year veteran of the industry, Michael has been a system operator, application developer, analyst and project manager in a variety of industries including Construction, Transportation, Retail, Wholesale and Oil & Gas. He currently specializes in non-standard user and machine interfaces to DB2 on IBM i.


Past Meetings

2011-10-01, Meetings, Director of Technology

Click here to see a list of all past MMSA Meetings.

COMMON's Archived Webcasts

2011-08-02, Education, Michael Daly

Webcasts are exclusively free for COMMON members, and offer a great option to stay up-to-date on the latest in Power Systems-related education. They are delivered by recognized speakers, and offer members the flexibility to participate in the hour-long Webcasts from anywhere they have Internet access.

The monthly Webcasts are also archived, creating a great knowledgebase of Power Systems-related education that you can access at your own leisure and review them at your own pace. COMMON Webcasts have immeasurable ROI on your membership dollars, giving you access to leading-edge education that can immediately impact your work, without any additional cost. Below are some of the recent COMMON Webcasts that have taken place...all available free to COMMON members, and delivered by industry experts on the latest topics.

  • Mobile and Cloud Computing with the IBM i
    Speaker: Eamon Musallam, looksoftware
  • Everything You Need to Know to Get Started with the New Systems Director Navigator Console
    Speaker: Pete Massiello, iTech Solutions Group
  • Enhancing Your Existing RPG Applications with PHP
    Speaker: Brian May, Garan Incorporated
  • AIX Business Resiliency and Disaster Recovery
    Speaker: Ferenc Gyurcsan, Vision Solutions
  • IBM i Performance Data Collectors and Investigator
    Speaker: Dawn May, IBM
  • Best Practices for IBM i Performance Management
    Speaker: Dawn May, IBM
  • What You Need to Know and Understand to do Successful IBM i Upgrades 6.1.1 & 7.1
    Speaker: Pete Massiello, iTech Solutions Group, LLC
  • Open Source Report Writing Tools for IBM i
    Speaker: Pete Helgren, Value Added Software, Inc.
  • IBM i 7.1 Overview
    Speaker: Steve Will, IBM

View the complete list of archived Webcasts and access them at

Learn more about upcoming Webcasts and register online at