2 possible reasons. If your temp file was close to the max setting, that might do it. Run Disc Cleanup utility reguarly. Or if the IT guys were using a new version of Excel than you were. There are memory limits that are internal to Excel and the newer versions have a larger limit.
Excel 95...
Geoff,
Work on your people skills.
BillyBunter,
There are internal limits in Excel for formula memory.
Excel 95, Excel 97 and Excel 2000 are limited to 64MB
Excel 2002 is limited to 128MB
Excel 2003 is limited to 64MB 1 Gig
Copy and paste the code below to notepad and save as filename.cmd on your desk top. Then drag and drop any file from the folder you want to list and a .txt file will open showing the contents of the folder. You can then copy and paste to Excel and then use the columns-to-text option to seperate...
I have also had good luck using a null string test.
if nullstr DREFF
Something to keep in mind...if your input file was originally an Excel file and there were a lot of empty rows before the file was saved (in your case as a comma delimited .csv) then the EOF character can be thousands of...
I had noticed it with previous versions as well, but not to this degree. I'm currently using v4.8.
If you create several copies of the same script and give them unique names, then the problem does not occur (that I have noticed). I had not considered that the file ID's being the same, might be...
I have been having a problem when using multiple telnet sessions to transmit data with the same script. Occassionaly one session will transmit data from an input file that another session has open. It does not seem to be an issue if the sessions are running different scripts, only when running...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.