Posted to microsoft.public.excel.programming

Thomas[_23_] Thomas[_23_] is offline

external usenet poster

Posts: 2

Error 1004, clean memory?

High

I use my VBA-code (load data-files, plot data, export diagramms, unload
data and delete diagramm).
After about 30 datasets an error 1004 appears. If I restart with the
30th dataset first everything works fine. Therefore I guess something
like memory overload is the reason.

Does anybody know the error?
Is there any VBA-command to clean memory?

Thanks

Thomas

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
run time error 1004 general odbc error excel 2003 vba	Mentos	Excel Programming	5	January 24th 11 02:56 PM
How to clean the memory for undo?	Eric	Excel Discussion (Misc queries)	3	October 29th 07 12:15 AM
How to handle error 8007000e Memory Error	L. A. M.	Excel Programming	6	June 28th 05 04:05 AM
Error 1004 - Out of Memory	m4nd4li4	Excel Programming	1	July 13th 04 03:28 PM
Error 1004 - Out of Memory	m4nd4li4	Excel Programming	2	July 13th 04 10:49 AM

All times are GMT +1. The time now is 09:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us