Export Arrays to CSV Files and Vice Versa

Category:

Lists, Collections and Arrays

Type:

Modules

Difficulty:

Beginning

Author:

Peter Wester

Version Compatibility: Visual Basic 6

More information:

SaveArrayAsCSVFile.bas contains:

- subroutine 'SaveAsCSV' to export an array (as double) to a csv file.

' Syntax:
' SaveAsCSV dMyArray, sMyFileName, [sMyDelimiter]

- function ImportCSVinArray to import a csv file into an array (as double).
' Syntax:
' dMyArray() = ImportCSVinArray (sMyFileName, [sMyDelimiter])

The module is shown in the demo that will create c:\temp\demo.csv from an array, and will import that file into an array. To see the latter, break the application and call the content of array dChrom.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download saveascsv.zip