Not that I know of.

you might be interested to look into PowerBI to aggregate the data - but even this will require it to lock and open the data file.

I've done what you have described - but you just gotta open dat file.
you can open silently and in read only mode.

I would also break your sub down into smaller chunks
> get/manage list of files to open, and call each in turn
> pass name to sub to open file, and return data array
> pass array to sub to write data to dest sheet

this will simplify your job a lot