Skip to Main Content
Excel 2003 VBA Programmer's Reference
book

Excel 2003 VBA Programmer's Reference

by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg
July 2004
Beginner content levelBeginner
1176 pages
27h 45m
English
Wrox
Content preview from Excel 2003 VBA Programmer's Reference

29

XML and Excel

Sometimes it is difficult to tell which technologies one should care about and which one can ignore. Do you remember DDE? Have you ever heard of SGML? In truth, some technologies (DDE but not SGML completely) can be safely ignored because they are waystation technologies that are stepping stones to something better. Then, sometimes a technology arrives and really can't be ignored. XML is such a time.

A refined question is can Excel VBA programmers afford to ignore XML? And an equally refined answer is probably not for long. XML is quickly becoming the definitive language of the Internet much as English has become the language of technology. In this chapter we will explore XML, beginning with a brief discussion of what it is, and we will show you a few of the things you can do with XML vis-a-vis Excel.

What Is XML?

XML, or eXtensible Markup Language, is a derivative of SGML, or Standard Generalized Markup Language. XML is a markup language like HTML that contains data and things that describe the data. What is important about XML is that XML is self-describing in nature and that XML is just text. Because XML is self-describing it can be used to describe just about anything, and because XML is text it can easily be transported across networks very easily, including the biggest network, the Internet. The Internet will handle other things besides text, but TCP/IP networks really like text.

Because XML is text, it is very easy to manage and transmit. Because XML contains ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2007 VBA Programming with XML and ASP

Excel 2007 VBA Programming with XML and ASP

Julitta Korol
Microsoft® Office Excel 2003 Programming Inside Out

Microsoft® Office Excel 2003 Programming Inside Out

Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Access™ 2007 VBA Programmer's Reference

Access™ 2007 VBA Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey Griffith, Armen Stein

Publisher Resources

ISBN: 9780764556609Purchase book