I need to read hundreds of Excel files to count and retrieve data only from of highlighted cells. I’ve tried the code below, but I encounter an OLE error when processing more than 60 files. Is there a better approach I could use, such as PowerShell, SQL, Python or another application?

I need to read hundreds of Excel files to count and retrieve data only from of highlighted cells. I’ve tried the code below, but I encounter an OLE error when processing more than 60 files. Is there a better approach I could use, such as PowerShell, SQL, Python or another application?

I need to read hundreds of Excel files to count and retrieve data only from of highlighted cells. I’ve tried the code below, but I encounter an OLE error when processing more than 60 files. Is there a better approach I could use, such as PowerShell, SQL, Python or another application?