Export (0) Print
Expand All
Expand Minimize

Application.CreateAdditionalData Method

Office 2007
Creates an AdditionalData object that can be used to add additional tables and queries to the parent table that is being exported by the ExportXML method.

Syntax

expression.CreateAdditionalData

expression   A variable that represents an Application object.

Return Value
AdditionalData

Example

The following example exports the contents of the Customers table in the Northwind Traders sample database, along with the contents of the Orders and Orders Details tables, to an XML data file named Customer Orders.xml.

Visual Basic for Applications
Sub ExportCustomerOrderData()
    Dim objOrderInfo As AdditionalData
    
    Set objOrderInfo = Application.CreateAdditionalData()
    
    ' Add the Orders and Order Details tables to the data to be exported.
    objOrderInfo.Add "Orders"
    objOrderInfo.Add "Order Details"
    
    ' Export the contents of the Customers table. The Orders and Order
    ' Details tables will be included in the XML file.
    Application.ExportXML ObjectType:=acExportTable, DataSource:="Customers", _
                          DataTarget:="Customer Orders.xml", _
                          AdditionalData:=objOrderInfo
End Sub



Community Additions

ADD
Show:
© 2014 Microsoft