Option Explicit
Dim rowcount As Long, filepath As String
Sub convertoCSV()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
rowcount = ThisWorkbook.Sheets(1).Range("A1").End(xlDown).Row
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Select a path to store file"
If .Show = True Then
filepath = .SelectedItems(1) & "\"
'converting into text format
ThisWorkbook.Sheets(1).Range("A:A").NumberFormat = "@"
ThisWorkbook.SaveAs Filename:=filepath & "Somu.csv", FileFormat:=xlCSV, CreateBackup:=False
Else
MsgBox "Folder for *.CSV file not selected"
End If
End With
End Sub
Dim rowcount As Long, filepath As String
Sub convertoCSV()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
rowcount = ThisWorkbook.Sheets(1).Range("A1").End(xlDown).Row
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Select a path to store file"
If .Show = True Then
filepath = .SelectedItems(1) & "\"
'converting into text format
ThisWorkbook.Sheets(1).Range("A:A").NumberFormat = "@"
ThisWorkbook.SaveAs Filename:=filepath & "Somu.csv", FileFormat:=xlCSV, CreateBackup:=False
Else
MsgBox "Folder for *.CSV file not selected"
End If
End With
End Sub
No comments:
Post a Comment