• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 784
  • Last Modified:

How do I send MSFLEXGrid data to an XML file please?

Please show some sample code of how to export MSFLEXGrid data to an XML file please?
0
yyuubum2
Asked:
yyuubum2
  • 3
  • 2
1 Solution
 
bruintjeCommented:
Hi DataDudes,
----------

there are 2 ways shown here, the first in a loop through the grid
source: http://tinyurl.com/p8lgg

think the second one is elegant

Set rs = New ADODB.Recordset
Set rs = Mymsflexgrid.DataSource
stArchive = "c:\export.xml"
rs.Save stArchive, adPersistXML

----------
bruintje
share what you know, learn what you don't
0
 
yyuubum2Author Commented:
bruintje:
  I'm getting an error on the line:
 rs.Save stArchivo, adPersistXML
"object required" ??
0
 
yyuubum2Author Commented:
bruintje:
the second won't work for me because my grid is populated by several sources not just a recordset.
the second one will work but the code doesn't create the XML schema just the XML for the data.
Can you help me with the schema
0
 
bruintjeCommented:
i guess you meant the first one with the loop to work for you, deriving a schema from a xml file is pretty daunting however in plain VB and i would suggest you ask a new question for that

maybe with a pointer to the XML TA
0
 
bruintjeCommented:
the question was answered
but there was something missing in the formulation leading to a follow up question about the schema
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now