O'Reilly logo

Programming Excel with VBA: A Practical Real-World Guide by Flavio Morgado

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© © 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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required