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

Flavio Morgado, Programming Excel with VBA, 10.1007/978-1-4842-2205-8_7

7. Using Excel as a Database Repository

Flavio Morgado

(1)Rio de Janeiro, Brazil

Microsoft Excel was conceived to produce tables of calculated data, and because of its ability to easily produce calculated worksheets to manage business information, many people also use it as a way to store precious business data.

This data storage happens by either making a workbook file copy, managing the data using some file name strategy, making copies of a predefined sheet tab inside the workbook, or creating sets of similar data inside the same Excel workbook file.

Using all the VBA knowledge you’ve built up so far and a good code strategy, ...

Get Programming Excel with VBA: A Practical Real-World Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.