Not Enough Memory Excel Macro 
Author Message
 Not Enough Memory Excel Macro

I saw a previous post on this subject and am having the
same problem.  I have a worksheet that contains a list of
filenames that I need to import, format, print, close the
file, and go to the next file and repeat the process.  
What I am actually doing is creating invoices.  Here's the

1) The file to be opened is a tab-delimited file.  I
created a macro in the original filelist worksheet that
grabs the filename from a cell, goes to "Open File", it
imports the file configuring each column the way I want
(I.E. General, Text, etc.).  It then formats each column
so that is autofits, searches for certain keywords that I
want to make bold, change font size, etc.  It then prints
the file, closes it (without saving the changes), grabs
the next filename, and repeats the process.

THE PROBLEM:  The list of files to open is currently
around 205 files, but this will grow.  It gets through
about 100 files then gives me "NOT ENOUGH MEMORY"
or "INVALID PAGE FAULT" errors.  I have increased the
memory from 128MB to 512MB and still have the same problem
so I know its not the memory.  I have noticed 2 different
files that get the "INVALID PAGE FAULT" error.  The 2

Is there some kind of limitation in Excel as far as
opening and closing tab-delimited files?  Any input would
be greatly appreciated.  Anyone who is willing to give me
some input can call me toll-free at 1-800-582-1173 and
just ask for Tom.  This is a major problem for me, so any
suggestions are very much appreciated.  Thanks!

Fri, 14 Oct 2005 23:23:34 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Not Enough Memory

2. Not enough memory??

3. error 7 in access 7.0 not enough memory

4. Not enough memory (Error 2004)

5. Not enough memory !!

6. not enough memory to run

7. There is not enough memory or disk space to run word

8. There is not enough memory or disk space to run word

9. "not enough memory......"

10. Not enough memory - too big code

11. Not enough memory

12. "Not enough memory" error during compile


Powered by phpBB® Forum Software