A Comma Separated Value (CSV) file is a plain text file that has a single record on each line. Each line is separated by a comma. A CSV file is sometimes called a comma delimited file. You can work with CSV files in Microsoft Excel and it’s possible to get Visual Basic for Applications (VBA) to do the work for you, including opening the file at the push of a button. Sub opencsv() ’ opencsv Macro Workbooks.Open Filename:= _ “C:\Desktop\myfile.csv” End Sub Writer Bio
