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

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