I am using excel 10 on windows 10. I have 8GB ram and am using about 33% of it.
My personal file is 6274kb. It was at 14mb when it ran out of memory, so I have cut it down.
My problem is when I try to change the name of a public sub from "R821020F2vv" to "R821020F2L105" I get the message "Out of memory"
I have removed and reloaded office 10. I have no active add-ins
Any help would be greatly appreciated.
Search this Excel Forum for "Styles." Paul has a couple of posts about removing them shrinking File sizes drastically.
Search the internet for Excel Diet.
I am having a similar issue,on my computer, just not related to Excel in any way. Using Ctrl+Alt+Del to open the Task manager look for any tasks that are taking up far more memory than you would expect. For example, in WinXP, other than my internet browser, no process takes even close to 100MB of memory, but it is using 136MB.
Make sure that you have no unsaved data before you End that Process.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
thanks for that I will check asap
I've actually uninstalled windows 10 from my laptop as it created numerous "memory issues".
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Also try
http://www.appspro.com/Utilities/CodeCleaner.htm
[QUOTE][During the process of creating VBA programs a lot of junk code builds up in your files. If you don't clean your files periodically you will begin to experience strange problems caused by this extra baggage. Cleaning a project involves exporting the contents of all its VBComponents to text files, deleting the components and then importing the components back from the text files./QUOTE]
which is different than ExcelDiet
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Thanks for all of the comments above.
CodeCleaner - I have installed it but cannot find it. I have gone to options > Add-ins > Manage Add-ins > Com Add-ins > Go - this brings up a box with nothing in it. Anyone know what I doing wrong. Please advise.
If it's installed, you can see in in [Options], [Addins]
You 'might' have to Browse to it and add manually. In Win10 it's in C:\Program Files (x86)\AppsPro\CodeCleaner
There are some Installation Instructions that are important also, so make sure to do these first
Before installing the Code Cleaner you must set your security to trust access to Visual Basic projects.
- Excel 2010 and Later - Choose File > Options > Trust Center > Trust Center Settings > Macro Settings. Check the checkbox labeled Trust Access to Visual Basic Project and click OK twice to finish.
On the editor side it's under [Tools]
Capture.JPGCapture1.JPG
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Thanks for that Paul
I now have it up and running and the file size is a whole lot smaller.
Ta,
Martin
Posting Permissions
Reply With Quote
