Hi,
I have a VBA project that opens many files, extracts info, then closes them
(between 10 & 500 files sequentially).

I open the data file, get what I need, close it, then open the next data file.

The files themselves are all pretty small - each under 60k.

However, as the application cycles through all the files, the memory usage
in Task Manager keeps growing and the app slows down.

I've checked in VBA Editor after it's done and it shows all the files that I
opened and closed.

Can someone show me an example of the proper way to handle files so that the
memory is actually released back to the system?

Thanks!
MikeZz