Hi Guys!
I am trying to save a selected column in excel 2007 but I don't know how to save it in xml file.
I have started some codes here but it didn't save the column..Can you please help me?

Private Sub Browse_Click()
Dim sFolderName As String, fDialog As FileDialog, ret As Long
Set fDialog = Application.FileDialog(msoFileDialogSaveAs)
ret = fDialog.Show
If ret <> 0 Then
sFolderName = fDialog.SelectedItems(1) & Application.PathSeparator
MsgBox sFolderName
Else
MsgBox "User pressed cancel"
End If
Set fDialog = Nothing


End Sub

Private Sub Export2_Click()
If TextPath.Text = Nothing Or fDialog.SelectedPath = "" Then
TextPath.Clear
MsgBox.Show "Empty path is not allowed..." & vbCrLf & "Please select a path to save the data."
Else


MsgBox "Finished exporting." & vbCrLf & "You can find the data on" _
& vbCrLf & TextPath.Text, "", MessageBoxButtons.OK, MessageBoxIcon.Information

TextPath.Clear

End If
End Sub