Macro to clear memory Cache

[Howardc1001]

I have a macro to import data and perform various other things

However if I run a second macro to find and replace various data , it cannot perform. I then Close Excel and then run this macro and it does what it needs to do

The reason for it not running after running the first macro it that there is not enough memory (I have 16 GB of Ram use an I7 3.6 GHZ Processor)

I am look for code that will clear the Memory cashe and allow me to run the second macro without having to close Excel


I have tried using the code below at the end of my code to free up memory but it does not clear the memory cashe

Please Login or Register  to view this content.

It would be appreciated if someone could assist me

[6StringJazzer]

First, why do you think that memory is the problem? Windows memory caching is a very low-level process and I don't think you can do anything about it in VBA. And I doubt this is your problem.

However, you may have other problems we need to look at, like effective memory management in your first macro. Please post your code (use CODE tags).

The code you showed here just puts the null string in the clipboard. The clipboard is almost certainly not using 16GB of memory.

[Howardc1001]

Thanks for the reply

See my first macro which combines several macros

Please Login or Register  to view this content.

[6StringJazzer]

This code isn't doing anything that leaves anything in memory. What exactly happens here: "it cannot perform"? What do you expect and what actually happens? Do you get an error message?

[Howardc1001]

When I run a seperate Macro to Replace Space between numbers, I won't do this. I then close Excel, then open the workbook and the macro runs perfectly.

I am not sure why this does this