Access.2007.VBA.Bibl..

(John Hannent) #1
FIGURE 10.30
An XML file opened in Internet Explorer.

You can also open an XML file in Excel. After selecting it, you get an Open XML dialog with three
options, as shown in Figure 10.31. To see what the formatted XML data looks like, select the “As
an XML table” option.

FIGURE 10.31
Three options for opening an XML file in Excel.

Part II Writing VBA Code to Exchange Data between Office Components

Free download pdf