Output Query to XML button 1

[Triacona]

Dear All,

Thanks for a great forum.

My problem is as such.

I have a form MainScreen
It has a fields, txtPath which contains the path to where it should save the document, sFullPath which is the ListCP and txtPath combined.

I am trying to export the query chosen in the list (ListCP) to XML format

I have only succeeded in exporting the query to xls format, as below.

Private Sub CpOutputQueryToXML_Click()

Dim stDocName As String
Dim FullPath As String
stDocName = ListCP
sFullPath = txtPath & ListCP & ".xls"

    DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, sFullPath, True
 

End Sub

What do I need to change in order to export in to XML?

Thank you in advance for your help!

Thank you,

Kind regards

Triacona

 

[PHV]

What about the Application.ExportXML method ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Triacona]

Dear PHV,

Thank you for your help

How would I use that?

Private Sub CpOutputQueryToXML_Click()

Dim stDocName As String
Dim FullPath As String

stDocName = ListCP
sFullPath = txtPath & ListCP & ".xls"    

   DoCmd.Application.ExportXML acOutputQuery, stDocName, acFormatXLS, sFullPath, True 

End Sub

Thanks in advance for your help

Thank you,

Kind regards

Triacona

 

[PHV]

A starting point:

Private Sub CpOutputQueryToXML_Click()
Application.ExportXML acExportQuery, Me!ListCP, Me!txtPath & Me!ListCP & ".xlm"
End Sub

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Triacona]

Dear PHV,

Thank you in works brilliantly have a STAR!

What does the Me! stand for?

Also do you know of any XML readers that I can view an XML with?

I try to open the exported XML in Excel but it says it has an invalid character?

I corrected your code is this correct? Or is this why I cann't open it in Excel?

Private Sub CpOutputQueryToXML_Click()

Application.ExportXML acExportQuery, Me!ListCP, Me!txtPath & Me!ListCP & [b][highlight]".xml"[/highlight][/b]

End Sub

Thank you very much


Thank you,

Kind regards

Triacona

 

[PHV]

Sorry for the typo :~/