I have created an Excel document with columns A to J as a list with the cells mapped to an Xml schema. I have written the VB script below to export the data on button click, once inputed, to an external Xml file. What I would like to do but, have no idea how to go about it, is to have some kind of yes/no check for each row of data. If yes then it gets exported, if no not. Any help is appeciated... thanks.
My script so far:
Private Sub CommandButton1_Click()
Call ActiveWorkbook.XmlMaps("Xml_Map").Export("MyUrl", True)
End Sub
My script so far:
Private Sub CommandButton1_Click()
Call ActiveWorkbook.XmlMaps("Xml_Map").Export("MyUrl", True)
End Sub
