Advertisement

Creating and Setting a Worksheet Database Class

  • Flavio Morgado
Chapter

Abstract

In the previous chapter you studied how to use Excel as a database repository, using a programmable approach based on a data validation list filled with a New Record item followed by all saved records and a simple strategy to save any one-to-many record database relationship on unused worksheet rows. The database engine was based on some Excel object events (Worksheet.Change, Worksheet.SelectionChange, and Workbook events.BeforeClose) and a punch of generic procedures that use module-level constant values to load, save, and delete worksheet application records.

Keywords

Class Module Code Module Object Variable Record Cell Database Property 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© © The Editor(s) (if applicable) and The Author(s) 2016

Authors and Affiliations

  • Flavio Morgado
    • 1
  1. 1.Rio de JaneiroBrazil

Personalised recommendations