Automation Examples

• Ex1 - Multi-monitor Spreadsheets

  Take a look at something really interesting. Spreadsheets using more than one CRT/LCD display.
  
  

• Ex2 - A Simple But Highly Automated Spreadsheet Exchanging Data With An ODBC Database

  This is a good basic example of an advanced automation spreadsheet that exchanges data with a database.
  
  

• Ex3 - Multi-monitor Charts and Data

  This is another multi-monitor spreadsheet example showing the value of more than one display when working with data and charts.
  
  

• Ex4 - Spreadsheets With Advanced Graphics

  This example shows the many possibilities of Excel's advanced graphics capability.
  
  

• Ex5 - Spreadsheets and the Web

  This example shows the ability of spreadsheets to go anywhere and stay connected to your data source. These spreadsheets exchange data with web pages.
  
  

• Ex6 - Multi - Window Spreadsheets

  This feature has been around as long as "Windows".This was the whole purpose of the window object model.Unfortunately it is not easy to control especially when many different people use the same spreadsheet. automation simplifies this in many ways.
  
  

• Ex7 - Spreadsheets Using Advanced Functions

  This example shows several spreadsheets that contain complex array and non-arrayed custom functions. The functions include cell and cell array driven queries based on referenced ranges in the cell formulas.It also shows a simple one that you may want to use if you use Vlookups or Hlookups very often.
  
  

• Ex8 - Spreadsheets Using OLE Automation

  This example shows several OLE examples including : 1.) a spreadsheet that was controlled by an enterprise resource planning system to produce complex financial statements 2.) a spreadsheet that contained an embedded internet explorer webbrowser.
  
  

  Links To Other Sections Of This Site

  • Technology
  • About Us
  • Contact Us
  • Frequently Asked Questions
  • Links
  • Home Page