Exportxml - I can't get it to work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Private Sub Command93_Click()
Application.ExportXML
ObjectType = acExportForm "PORTABLES DATA ENTRY PAGE"
DataSource = "PORTABLES DATA ENTRY PAGE"
DataTarget = "Export.xml"
PresentationTarget = "Export.xsl"
End Sub


What am I doing wrong?
 
I'm not very familiar with the ExportXML method, but there are some basic
VBA syntax errors here - perhaps I can at least help you with those, and if
you still have problems after that, perhaps someone more familiar with the
ExportXML method might like to join in ...

First, a VBA statement must either be all on one line, or you must include
line separation characters - a space followed by an underscore (" _") at the
end of each line except the last. And second, when using named arguments,
you need to use a colon followed by an equals sign (":="). Third, the
ObjectType argument can only accept a member of the acExportXMLObjectType
enumeration, i.e. acExportForm, acExportFunction, acExportQuery, etc., the
addition of the string "PORTABLES ... " etc after acExportForm in the third
line of your code is not valid. And fourth, arguments must be separated by
commas.

Taking into account all of the above, your original code, translated into
valid VBA syntax, would look like this ...

Private Sub Command93_Click()

Application.ExportXML _
ObjectType:=acExportForm, _
DataSource:="PORTABLES DATA ENTRY PAGE", _
DataTarget:="Export.xml", _
PresentationTarget:="Export.xsl"

End Sub
 
It works now, thanks for the help.

If I want to export only the information on the screen, in this particular
form, how would I change the code to represent this? I only need the info on
this page, and not the whole database.

Thanks again
 
I would assume that one way would be to create a parameter query based on
the key field(s) on the form, and export the query, rather than the form.
 
Back
Top