How to import Excel file to CSV Step-by-Step

**champs** · 03-03-2009, 02:13 AM

Good morning members,

I have an excel file that I would like from a click of a button import into a CSV file.please give me your suggestions

Thanks

Webtekr · 03-03-2009, 05:53 AM

So let me get this right, you have an Excel file and you do not have it linked to Access but would like to convert the xls to csv? Why not simply open the spreadsheet in Excel and save it as a csv?

If you have it linked Access as an Excel spreadsheet then create a macro using the TransferSpreadsheet command.

**ExlGuru** · 04-15-2009, 03:17 AM

Try this

Public Sub SaveToText()
Dim WrkSheet As Worksheet
Dim CurrFormat As XlFileFormat

CurrFormat = xlCSV
Set WrkSheet = ThisWorkbook.Worksheets(1)

WrkSheet.SaveAs "C:\MyFile.csv", CurrFormat

Set WrkSheet = Nothing
End Sub

To save the entire workbook use this line:

ThisWorkbook.SaveAs "MyFilePath", CurrFormat

Hope this helps