First time posting a question here but already learnt a lot these past weeks thanks to the forum.
I am having an issue when I plug the Excel Application Scope in a For Each loop to go through the whole bunch of excel files within a specific folder.
For whatever reason the array of strings variable capturing my list of excel documents is not getting through the WorkBook Path when I specific : Files.ToString.
The debug output is that the file cannot be opened.
My logic is working when i do specific a workbook in the path.
Any ideas guys?