-
Sleeper: Excel cannot complete this task with available resources.
my program is 51MB and it does copy and paste data for many times. then when i try to run my program this error will appear:
"excel cannot complete this task with available resources. choose less data or close other applications.."
can anyone tells me what is the cause and the resolution of this error.
thank you.
-
Hi zieylar, welcome to VBAX,
One (or maybe two) things can lie at the bottom of this;
Basically, you are exceeding the memory (RAM) resources of your PC.
1) Make sure you put Application.CutCopyMode = False after each paste (this clears the clip board for the next copy)
2) 51MB is a large file, if you're opening and closing other files as well, these are all held in memory until you actually QUIT the application - just closing them does NOT take them out of the memory store. (Try to keep the number of files that've been opened down to a minimum)
HTH,
John
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
-
thank you John.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules