Excel Application Scope - Failed to open array of strings

Hello everyone,

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?

Cheers,

Hi,

Can you try to set file.toString instead of Files.ToString in Workbookpath property of Excel Application Scope?

Regards,

2 Likes

Hey Yoichi, it works Thanks

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.