Reading "*xls" File in a Folder via vb.net

Help Studio
,
6

Hi @Kuki_Force

Please remove for folder in folder. You do not need that. That is what is making the files inside the folder to be looped

getFiles = Directory.GetFiles(FolderLocation,"*xls")
Console.WriteLine("Number of Files : " + getFiles.Count.ToString)

	For Each Files As String In getFiles
		lst_KeepExcelDoc.Add(Files)
Next

Cheers

1 Like