Clearing memory when processing files in Excel

[jrisebo]

We have a process where we have many data files (txt files) that excel will open, read a bit of data, and then move on to the next one. It seems to bomb out based on what I think is a memory error.

Is there a way to clear the memory the computer uses in the code, i.e. it opens the file, reads the text, pastes it where we want it, and then clears its memory for the next file?

Thanks

 

[Bond00]

Thanks, sorry was out for an extended time. Will review and let you know if it works.

Alright thanks let me know when you find out.

 

[jrisebo]

Yes, it worked. Spreadsheet completes w/o error. Thanks