Excel 2007 VBA Programming with XML and ASP offers a hands-on approach for those looking to extend and customize Excel functionality. From recording a simple macro and writing VBA code to working with XML documents and using ASP to access and display data, this book takes you on a programming journey that will change the way you work with Excel! Learn how to: Automate spreadsheet tasks with macros. Write VBA code to program PivotTables, generate charts, build dialog boxes, and customize the Ribbon. Handle errors and debug programs. Create hyperlinks and publish HTML files. Retrieve data from the web directly into Excel. Develop and manipulate smart tags using XML....

Access 2007 Programming by Example with VBA, XML, and ASP shows non-programmers how Access databases can be created, managed, and customized with Visual Basic for Applications (VBA) a powerful programming language built into Access. Hundreds of hands-on examples and projects throughout the book show users how to take charge of their Access databases with programming. Learn how to: Write and debug your programming code with the Visual Basic Editor. Access and manipulate databases with Data Access Objects (DAO) and ActiveX Data Objects (ADO). Use the Data Definition Language (DDL) to enforce data integrity and manage database security. Modify the behavior of forms, reports, and controls by writing event procedures. Publish dynamic Access data to the web using Active Server Pages (ASP) and Extensible Markup Language (XML). Work with the new features for tables, forms, reports, macros, and templates that are available in the Access 2007 user interface....

This book is designed to take Microsoft Access users to the next step in programming. Its five parts cover an intro-duction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. With more than 300 hands-on examples and 11 custom projects, users can quickly build the toolset required for developing their own database solutions. Learn How To: Write and debug your programming code with the Visual Basic Editor. Understand and use common VBA programming structures such as conditions, loops, arrays, and collections. Create and manage databases with ActiveX Data Objects (ADO). Perform database tasks with Jet/Access Structured Query Language (SQL) and its Data Definition Language (DDL) component. Query and manipulate your database from a web browser with Active Server Pages (ASP). Export and import Access data to and from XML both manually and programmatically....