Excel 2007 VBA programming with XML and ASP [electronic resource] /
Julitta Korol.
- Plano, Tex. : Wordware Pub., c2009.
- 1 online resource (xxiii, 879 p.) : ill.
Description based on print version record. Includes index.
"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."--Resource description page.
CL0500000083 Safari Books Online
Microsoft Excel (Computer file) Microsoft Visual Basic for applications. Active server pages.
Electronic spreadsheets. XML (Document markup language) Computer software--Development.