[Anwsered] Convert Excel data to CSV |
Convert Excel data to CSV
I have asimilarquestionlike
Costa SI.
I want to convert a
n Excelfile inCSV
file .
Row 1 is theheadersin text format.
The dataare in A2 :CT400 .
I want to save the project in the path“C:\CSV_Files”
(Workbook name is “ExcelToCSV” ,Worksheet name is “ExcelData”
and project’s name is “CSV_001”)
Again, thank you all in advance.
Anwsers to the Problem Convert Excel data to CSV
Download SmartPCFixer to Fix It (Free)
I presume you are looking for a macro to do the save, since Kosta SI was apparently seeking that type of solution.
I'm a little confused regarding what you want to save the file as, but I'm going to assume it is to be saved as a file named CSV_001.csv. But I think you may want to use the macro in other files lately, so the code below allows you to indicate the name
of the file as it is to be saved.
Sub SaveAsCSV()
Const SaveToPath = "C:\CSV_Files\"
Dim NameForCSVFile As String
'here is where you are asked to provide a filename
'don't enter the .csv part, so to save the file
'as CSV_001.csv, you would only enter CSV_001
NameForCSVFile = InputBox("Enter CSV Filename:", "Provide Filename", "")
'if you don't enter anything, we quit
If NameForCSVFile = "" Then
Exit Sub
End If
'the sheet to be saved must be selected, so we will do it
'automatically here in the code
Worksheets("ExcelData").Activate
'inhibit the display of all the CSV alerts/warnings
Application.DisplayAlerts = False
'do the save with file conversion
ActiveWorkbook.SaveAs Filename:=SaveToPath & NameForCSVFile & ".csv", _
FileFormat:=xlCSV, CreateBackup:=False
Application.DisplayAlerts = True
End Sub
I am free because I know that I alone am morally responsible for everything I do.
R.A.
Heinlein
Make Sure that your Computer Meets the System Requirements
You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:
Microsoft Windows Requirements :
- 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
- 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
- 16 GB available hard disk space (32-bit) or 20 GB (64-bit)
If your computer meets the minimum requirements above, then continue on…
Recommended Method to Repair the Problem: Convert Excel data to CSV:
How to Fix Convert Excel data to CSV with SmartPCFixer?
1. Download Error Fixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.
2. After the scan is finished, you can see the errors and problems which need to be fixed.
3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.
Related: Can We Exclude Zero Values In Datasets From Displaying In Pie Chart Graphs?,Can We Disable The Charms Bar In Windows 8?,Can Imessaging Be Used To Talk To Someover Over Seas Via Video,Can't Clear Print Queue (phantom Document?),Can You Print Two Or Three Spreadsheets On The Same Page. All Spreadsheets Are In The Same Workbook.,Cant Get IE To Pull Webpages When WEP Settings Are Appliedl; Can Only Access The Homepage????,Cant Open A Microsoft Excel File Directly From My Desktop,Cells Shifting On Save In Excel.,Change The Decimal Point To A Comma,Change Pages In My Documents,Computer Freezes During Video Or When Openining Browsers. Have To Hot Reboot Every Time.,Computer Wont Shutdown After Upgrading To Windows 8.1,Computer Hung After Wiindows Update,Computer Freezes Randomly In Windows 7.,Computer Will Not Select Desktops After Upgrade From Vista To Windows 7
Read More: Troubleshooter of Error: CONVERT classified pdf to word doc,How to Fix Error - Converting an .rtf document?,How to Fix Problem - Control Panel hangs and dllhost32.exe runs 100 %?,Control Center is incomplete! Please reinstall again. - Windows 8.1 upgrade,Fast Solution to Error: Control Panel not working.,Cell population from list depending on selection in previous cell,Changing auto open of pdf files with Adobe,Conditional format and blank cells,computer freezes works only in safe mode and BlueScreen Error BCCode: 116,Computer shuts down when it goes into sleep mode