In today's world of technology, it has become commonplace for companies to expect systems to communicate with each other in ways that were not possible just a decade ago. In this chapter, you explored ways to work with external data to facilitate communications between various systems. You learned VBA techniques for linking, importing, and exporting data to various sources, such as databases, spreadsheets, and text files. You also learned how to handle more advanced scenarios, such as sending e-mails programmatically and consuming Web services from your application. Web services allow applications on various platforms to exchange data upon request and have become an increasingly popular communication technique between systems.
Chapter 8 will build on this chapter by explaining how to export data in your application to reports and Web-enabled output.
Was this article helpful?