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
Bookmarks