Export to an excel document instead of XML

[Bertrand82]

Hi,



Im using the below code for rapid multiple xml-file exports.

Application.ExportXML ObjectType:=acExportTable, DataSource:="Table1", DataTarget:="C:\Table1.xml"
Application.ExportXML ObjectType:=acExportTable, DataSource:="Table2", DataTarget:="C:\Table2.xml"
Application.ExportXML ObjectType:=acExportTable, DataSource:="Table3", DataTarget:="C:\Table3.xml"

Works fine, but instead I need to get files in Excel-format. What should I change in my code?

br Bertrand

[JoeM]

Perhaps TransferSpreadsheet is what you are looking for?
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

[Bertrand82]

True, thanks, did not thought of that. A linked connetion is the best alternative.

br Bertrand