Not enough memory error - Can't open file

I have an Excel 2000 file in which I created a very long macro that basically 
copies indiviudal cells from one worksheet into another changing structure of 
the data basically. It worked fine when I ran it against 3 files I needed to 
copy the data from. When I tried to do a 4th file of the exact same format I 
got the not enough memory error. I shut down excel and the computer but I 
still get the error and can't open the macro file . Am I screwed? Or is there 
a way for me to retrieve - get my macro back so I can try modifying it or my 
process so I don't have this problem again. 

Thanks
John
0
jch (16)
3/10/2005 8:05:08 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
634 Views

Similar Articles

[PageSpeed] 22

"jch" <jch@discussions.microsoft.com> wrote in message
news:E6825E23-3EF5-40D8-8101-10A87A7890FD@microsoft.com...
> I have an Excel 2000 file in which I created a very long macro that
basically
> copies indiviudal cells from one worksheet into another changing structure
of
> the data basically. It worked fine when I ran it against 3 files I needed
to
> copy the data from. When I tried to do a 4th file of the exact same format
I
> got the not enough memory error. I shut down excel and the computer but I
> still get the error and can't open the macro file . Am I screwed? Or is
there
> a way for me to retrieve - get my macro back so I can try modifying it or
my
> process so I don't have this problem again.
>
> Thanks
> John
>

There's a limit to how big your macros can get. You have probably done
something wrong if you have exceeded this limit. How big is the macro? You
can probably break it up by creating private functions, procedures and
loops.

Best Regards,
Fredrik



0
3/10/2005 8:32:34 PM
Thanks Fredrik, 
I assumed I'd hit some limit or some such thing? The worksheet is 158k, I 
don't know how much of that is macro and how much is data? The problem is I 
can't open it at all to make any modifications. Too bad Excel can't prompt us 
about exceeding file size before we break the file. Do you know of anyway of 
getting access to the macro so I could at least salvage some of my work? 
Interestingly I can open the file in Word and view the data, but I don't have 
access to the macro from there.

Thanks
John


"Fredrik Wahlgren" wrote:

> 
> "jch" <jch@discussions.microsoft.com> wrote in message
> news:E6825E23-3EF5-40D8-8101-10A87A7890FD@microsoft.com...
> > I have an Excel 2000 file in which I created a very long macro that
> basically
> > copies indiviudal cells from one worksheet into another changing structure
> of
> > the data basically. It worked fine when I ran it against 3 files I needed
> to
> > copy the data from. When I tried to do a 4th file of the exact same format
> I
> > got the not enough memory error. I shut down excel and the computer but I
> > still get the error and can't open the macro file . Am I screwed? Or is
> there
> > a way for me to retrieve - get my macro back so I can try modifying it or
> my
> > process so I don't have this problem again.
> >
> > Thanks
> > John
> >
> 
> There's a limit to how big your macros can get. You have probably done
> something wrong if you have exceeded this limit. How big is the macro? You
> can probably break it up by creating private functions, procedures and
> loops.
> 
> Best Regards,
> Fredrik
> 
> 
> 
> 
0
jch (16)
3/10/2005 9:29:04 PM
Reply:

Similar Artilces:

Retrieve an External File, pdf, txt, jpeg... etc
I have a generic folder (c:/database/folder/)with a many different files that need to be referenced on a regular basis. The worst part is finding the file that is needed. What I am trying to do is to have the user add on a form the name of the file with the extension (such as .pdf, .doc, .txt, .jpg) where such information is stored. So lets say as an example that we want to retrieve the file name adobe.pdf. Using a form, how can I have a pull the exact file? Again, all files are stored in the same folder and path. Thanks in advanced!! Use the 'standard Windows Fil...

Exchange Delivery Delay (Error 4.4.7)
We recently installed SBS 2003 and are using Exchange 2003 for email. Everyone can log in and use exchange with no problems. All seems to be working ok. But some of the users are getting Non Delivery Reports. On some email messages. The reports are in the following formats: This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed. carlos.caxias@dywid.pt Reporting-MTA: dns;maildywid.Dywid.co.uk Final-Recipient: rfc822;carlos.caxias@dywid.pt Action: d...

Unable to open Attachments (Environment Wide)
Going to post this in the Exchange group, as I havent had any luck in the Outlook group. This may actually be a server security issue, but I am a bit lost on a solution. We recently migrated to Office XP at our corporate office. Since the upgrade, I am having several complaints of attachments not openning. After researching the issue, it appears be random and the current solution is to forward the message to the receiver, and then launch the attachment. The attachments are not blocked and are simple Word, Excel and PDF files. The user receives no error. Double clicking the attachmen...

Crystal Report Viewer Error
When trying to run reports through the CRM I get the following error: CrystalReportViewer: Information is needed before this report can be processed. This shows up in the popup window where the results of the report would normally show before you would press the print button. -- Chris Meredith Chris, This error is caused by 1)Installing Microsoft CRM on a computer that has an underscore in its name. OR 2)Security issues related to domain and Microsoft CRM setup. Microsoft has explained the causes and how to resolve this error in the following article. http://www.microsoft.com/download...

XL97 changes filenames upon open
Hi All........... Just started today...........when I open any .xls file, either C drive or network, by doubleclicking in WinExplorer, the name of the file is changed by XL adding a 1 to the end of the filename.............then won't "SAVE" back to where I got the file from, wants to "SAVE AS" in MyDocuments with the new filename............. If I open the same files by rightclick-open in WinExplorer they open normally.............if I open XL first, the same files open ok also.......... AutoCAD and WORD files still open ok by double-clicking. This a couple of...

Convert old PPT file
My company recently upgrade the office 2003 to office 2007. It works well for most of the users except one. He had thousands of old powerpoint slides which created around year 1996,1997. By using right click to check the file properties, it shows the the application name is 'Microsoft Powerpoint 4.0' .These file can be opened by powerpoint 2003 but can not being opened by powerpoint 2007. Does anyone have idea how I can bulk convert those files to powerpoint 2003 format? Thanks James Steve has a macro here http://www.pptfaq.com/FAQ00740.htm -- john ATSIGN PPTAl...

Server-Requested Client Action error: MoveCopy unable to create dest msg
I have a user receiving this error message. Server-Requested Client Action error: MoveCopy unable=20 to create dest msg Outlook 2002. Theare are no rules configured.=20 Any Idea? tks, Alisson S. Ara=FAjo ...

Runtime Error with Portfolio
I am getting an error message every time I try to look at my Portfolio in Money 2004. The message reads: Microsoft Visual C++ Runtime Library Runtime Error! Program: C;\Program Files\Microsoft Money\System\msmoney.exe This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information I was able to load it and even update the information I had in there for a day or two. But then it just stopped working. Does anybody know of a fix for this?? Thanks a lot in advance. Internet Explorer could ...

CRM report Error - Account Overview
Hi there, Is it possible if anyone could help me with the following problem.The Account Overview Report does not appear for one of the clients. When the report is opened the following error message appears: Error: Subreport could not be shown. Any ideas? Thank you in advance Lebo ...

coverting pub files to jpeg
How do i convert a multipage publisher file to jpeg so i can send to someone via email who does not have publisher? -- I am new to windows xp and am looking for help and guidance. I appreciate your time. Thanks people Convert it to pdf. You can get a free or inexpensive pdf converting program at: Primopdf at www.Primopdf.com it's free or a low cost program, PDF-XChange at; http://www.docu-track.com/ -- Don Vancouver USA "kezaaa" <kezaaa@discussions.microsoft.com> wrote in message news:E8546816-9E55-4BB3-B03F-1D42555F98F6@microsoft.com... > How do i conver...

error: 1026 JET_errRecordTooBig
Hi, On all domaincontrollers in our Windows 2003 environment, the following error occurs since one week: Internal error: The security descriptor propagation task encountered an error while processing the following object. The propagation of security descriptors may not be possible until the problem is corrected. Object: CN=internal 79219437,CN=Microsoft Exchange System Objects,DC=bnl,DC=capgemini,DC=com Additional Data Error value: -1026 JET_errRecordTooBig, Record larger than maximum size Internal ID: 20903d5 We use Exchange 2003 sp1, with all hotfixes applied. Backend is clus...

Viewing MDI files in Office 2008?
How do you view MDI files in Office 2008? I am a new Mac user so please simplify it for me! MDI files can only be viewed in Microsoft Office Document Imaging, and that application is not available on the Macintosh. On 18/02/08 4:18, in article ee8dd44.-1@webcrossing.caR9absDaxw, "Mac_Newbie@officeformac.com" <Mac_Newbie@officeformac.com> wrote: > How do you view MDI files in Office 2008? I am a new Mac user so please > simplify it for me! -- Michel Bintener Microsoft MVP Office:mac (Entourage & Word) *** Please always reply to the newsgroup. *** Additional to...

error log
I have this error in event viewer, in passive node (exch2k3 cluster win2k3), when i switch between nodes: Event Type: Error Event Source: ClusSvc Event Category: Checkpoint Mgr Event ID: 1082 Date: 17/03/2005 Time: 13.20.44 User: N/A Computer: Exchagne server Description: Cluster service failed to restore a registry key for resource Cluster Name when it was brought online. This error code was 3. Some changes may be lost. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. ...

How to open registry file both ASCII and Unicode versions
Hi, In my program i need to open a windows registry export file (both older ASCII REGEDIT4 and unicode regedit 5 formats) and parse the file for my programs requirements. The project is not and cannot be built as unicode (for other reasons). Once the file is opened I need to parse the file, read keys + values etc... Question is how do i do this? I have used CStdioFile, open as typeBinary and then fgetws(wcBuffer, nMax, importFile.m_pStream) Which works for unicode files, but how do i test whether a file is ASCII or Unicode in the first place? Any help would be much appreaciated, T...

Error installing CRM 3
Trying to install CRM on a development server that has just been rebuilt after disk failure and the install runs through until it attempts to grant permissions on the newly created databases. The CRM install is all on this machine i.e. webserver and sql server are the same box. The error message reads Action Microsoft.Crm.Setup.Server.GrantDatabaseAccessAction failed. Setup could not complete this action. This might be due to the fact that there are multiple Domain Controllers and they have not replicated nw Microsoft CRM information yet. If this is the case you have several options: ...

Letter Writing Assistant Error #3
When we try and print a letter in the letter writing program we receive a Header Record Delimiters error. It is asking for a field delimiter and a record delimiter. How do we correct this error. This was working correctly a couple weeks ago, and it works correctly on other machine sin the office, any thoughts or suggestions on how to correct this issue? Anybody have any thoughts or suggestions? ...

Unable to Overwrite Existing Network File
I have been searching in vain for a solution to this problem for quite some time. What happens is that even when running a simple MFC program (i.e. created from the Wizard & run), I cannot overwrite an existing network file. I can create new files on the network without a problem. Also, no other programs installed on my machine have this problem (notpad, Word, etc.). I have checked my network permissions and I have every permission available on the target directory with the exception of "Full Control", "Change Permissions", and "Take Ownership". Does anyo...

Outlook 2003-Cannot delete PST files
I started using trial version of Office Pro 2003. In Outlook, someow I ended up with 3 folders I want to delete at the left column under All Mail Folders. When I try to close them, I get "Operation failed. An object could not be found" message. Similar issue is discussed at KB292022, but it relates to Outlook 2000 and I could not find the key "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows Messaging Subsystem\Profiles\Microsoft Outlook Internet Settings\". I am not sure if I am using IMO or CW. Outlook 2003 does not indicate it at Help-About.... screen. Can anyone h...

Error when opening Webmail
When my external users use webmail for sbs 2003 with the settings set to Primium and they log in the straight away get the little yellow triangle at the bottom of the page saying 'errors on page'. But when I log in as Basic everything works, they really need to use Primium for the extra functianality. When I look at the errors they are as follows: - _______________________________________ Line: 15 Char: 30 Error: Object expected Code: 0 URL: https//ipaddress/exchange/user/inbox/? Cmd=contents _______________________________________ and ______________________________________...

Syntx error
I am getting a syntax error message in the following, any suggestions strReviewDateCriteria = "Not (tblStatusChoices.status) = "action complete"" Thanks Dave <maceslin@gmail.com> wrote in message news:ba8c58e9-2dec-4ef2-981d-2ce540fd9c23@u69g2000hse.googlegroups.com... >I am getting a syntax error message in the following, any suggestions > > strReviewDateCriteria = "Not (tblStatusChoices.status) = "action > complete"" > > Thanks > Dave Try: strReviewDateCriteria = "Not (tblStatusChoices.status) = 'action compl...

Print to a file
My program has some methods that print to a printer OK. But I need to put labels on those files afterwards so it would be better to print them to a file first. The program calls GetPrinterDC() before starting the printing. Is there some update that will permit the user to print to a file? Thanks, E-Jo Hello E-Jo, Glad to see you. Generally speaking, if you want to save and add the information in current dc to a file, you can create a dc from a bmp and blt all informaiton from the src dc to the bmp. I notice you would like to put labels on a file after it is printed. I am afraid I...

E000000*.log files
I have an awful lot of these files in c:\program files\exchsrvr\mdbdata\ Can I simply delete them? No - Do a full Exchange Aware backup (such as NTBackup) and it will remove them. -- Hope that helps, Dan Townsend This posting is provided "AS IS" with no warranties, and confers no rights. Please do not send email to this address, post a reply to this newsgroup. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "Hades" <no@spam.ta> wrote in message news:40333f6b$0$7066$ed9e5944@reading.news.pipex.net...

Save file as readonly with password
is there a way for access to export a file to word (.rtf) as a read only file with a built in password to unprotect it? -- Message posted via http://www.accessmonster.com ...

what is cannot complete operation error code 0x80040155
my clip art is gone how do I get it back You need to re-register the Ole32.dll Start, run, type in the open box regsvr32 ole32.dll If that doesn't work... You receive a "Clipart cannot complete the operation" error message when you try to insert clip art in an Office XP program or in an Office 2003 program http://support.microsoft.com/kb/889885/en-us -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "dredrhino" <dredrhino@discussions.microsoft...

Access 2003 file format advange?
We're upgrading our system from Access 2000 to Access 2003. I'm aware that version 2000 databases can be opened in Access 2003 without conversion, and it did, in fact open, but are there any benefits to converting the database to version 2003? Or, are there reasons why our 2000 database should NOT be converted to 2003? It's hard to beleive that it wouldn't matter one way or the other, and think there must be some advantage to converting to a file format of "2003" if we're using Access 2003. Many thanks in advance. On Tue, 17 Feb 2004 12:31:13 -0500, Si...