Given the code below:
'Open the CSV data file for reading
Set fs = CreateObject("Scripting.FileSystemObject") 'set the file system to the entire drive
Set f = fs.opentextfile(filepath, ForReading, TristateUseDefault) _
'set file using filepath and file system set above
While Not f.AtEndOfStream 'proceed with the following until end of file is reached
s = f.readline 'read in a line of data from .csv file
If s <> "" Then 'if the line is not blank
vline = Split(s, ",") 'create comma delimited array from .csv row
'want a msgbox command that would print all the entries in vline here
End If 'if s <> ""
Wend 'while not f.AtEndOfStream
What command/code would allow me to print all the entries in vline regardless of the size of the comma delimited array? Thanks.
Bookmarks