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

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

9. Exchanging Data Between Excel Applications

Flavio Morgado

(1)Rio de Janeiro, Brazil

Many worksheet applications base your analysis on external data. This is the case with USDA Food Composer.xlsm and any other nutritional worksheet application solution that uses the ARS-USDA nutrient tables as primary data source. They all used some version of the Standard Reference (SR) file at the time they were built, which must be updated when another SR version becomes available.

On the other hand, as you begin to use the SheetDBEngine worksheet database class to store worksheet data as records, improving the use of your solution, ...

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.