A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Programming
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Out of Memory



 
 
Thread Tools Display Modes
  #1  
Old November 20th 16, 11:08 PM posted to microsoft.public.excel.programming
Walter Briscoe
external usenet poster
 
Posts: 279
Default Out of Memory

I have just worked around a problem. It seems friendly to report my
experience.
I use Excel 2003 and most of my code is in PERSONAL.XLS.
I had created a new sub, which is a renaming of another.
I lost the plot and saved PERSONAL.XLS.
When I opened Excel again, I got an "Out of Memory" dialog box.
Throwing away a lot of redundant code did not help. I could run no code.
I moved PERSONAL.XLS away from Application.StartupPath.
I created an empty PERSONAL.XLS. (Save a dummy macro in Personal Macro
Workbook.)
Previously, I had copied Sub ExportAllComponents from somewhere.
(Possibly <https://www.experts-exchange.com/art...1457/Automate-
Exporting-all-Components-in-an-Excel-Project.html>)
I used that code on my old PERSONAL.XLS.
I imported the components, one at a time.
I hit problems with the need to set Tools/References and to define
types. Googling got me information to set references.
When I had got a compilable file, my new PERSONAL.XLS was about 2MB.
The old file was about 20MB. I have no notion what went wrong.
--
Walter Briscoe
Ads
  #2  
Old November 21st 16, 08:06 PM posted to microsoft.public.excel.programming
GS[_6_]
external usenet poster
 
Posts: 695
Default Out of Memory

> I have just worked around a problem. It seems friendly to report my
> experience.
> I use Excel 2003 and most of my code is in PERSONAL.XLS.
> I had created a new sub, which is a renaming of another.
> I lost the plot and saved PERSONAL.XLS.
> When I opened Excel again, I got an "Out of Memory" dialog box.
> Throwing away a lot of redundant code did not help. I could run no
> code. I moved PERSONAL.XLS away from Application.StartupPath.
> I created an empty PERSONAL.XLS. (Save a dummy macro in Personal
> Macro Workbook.)
> Previously, I had copied Sub ExportAllComponents from somewhere.
> (Possibly <https://www.experts-exchange.com/art...1457/Automate-
> Exporting-all-Components-in-an-Excel-Project.html>)
> I used that code on my old PERSONAL.XLS.
> I imported the components, one at a time.
> I hit problems with the need to set Tools/References and to define
> types. Googling got me information to set references.
> When I had got a compilable file, my new PERSONAL.XLS was about 2MB.
> The old file was about 20MB. I have no notion what went wrong.


Simply put.., this is an example of how some files get
corrupted/bloated for no apparent reason. You could have just renamed
your original file "Personal.xls.old" and opened it with macros
disabled, then drag-drop its components into your new one.

It would be very worth your while to download Rob Bovey's free
VbaCodeCleaner addin...

http://www.appspro.com/Utilities/CodeCleaner.htm

...and use it regularly for general maintenance.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #3  
Old November 23rd 16, 12:56 PM posted to microsoft.public.excel.programming
Walter Briscoe
external usenet poster
 
Posts: 279
Default Out of Memory

In message > of Mon, 21 Nov 2016 15:06:56 in
microsoft.public.excel.programming, GS > writes
>> I have just worked around a problem. It seems friendly to report my
>> experience.
>> I use Excel 2003 and most of my code is in PERSONAL.XLS.
>> I had created a new sub, which is a renaming of another.
>> I lost the plot and saved PERSONAL.XLS.
>> When I opened Excel again, I got an "Out of Memory" dialog box.
>> Throwing away a lot of redundant code did not help. I could run no
>>code. I moved PERSONAL.XLS away from Application.StartupPath.
>> I created an empty PERSONAL.XLS. (Save a dummy macro in Personal
>>Macro Workbook.)
>> Previously, I had copied Sub ExportAllComponents from somewhere.
>> (Possibly <https://www.experts-exchange.com/art...1457/Automate-
>> Exporting-all-Components-in-an-Excel-Project.html>)
>> I used that code on my old PERSONAL.XLS.
>> I imported the components, one at a time.
>> I hit problems with the need to set Tools/References and to define
>> types. Googling got me information to set references.
>> When I had got a compilable file, my new PERSONAL.XLS was about 2MB.
>> The old file was about 20MB. I have no notion what went wrong.

>
>Simply put.., this is an example of how some files get
>corrupted/bloated for no apparent reason. You could have just renamed
>your original file "Personal.xls.old" and opened it with macros
>disabled, then drag-drop its components into your new one.
>
>It would be very worth your while to download Rob Bovey's free
>VbaCodeCleaner addin...
>
> http://www.appspro.com/Utilities/CodeCleaner.htm
>
>..and use it regularly for general maintenance.
>


I previously downloaded it. It installed without error.
It just failed to add an entry to any of my VBIDE (Visual Basic
Integrated Development Environment) menus. Very frustrating as I can't
now find anything to do a similar job.
This is no longer available:
20160524 vba code cleaner orlando.mvps.org VBA CODE DECOMPILER AND
COMPACTOR C:\Users\IBM\AppData\Local\Temp\Temp1_VBADecompile r.zip\VBADec
ompiler.exe.
I got nowhere with:
20161105 vba excel cleaner http://www.spreadsheet1.com/vba-project-code-
cleaner-for-access-excel-powerpoint-word.html.

Thanks for the suggestion.
--
Walter Briscoe
  #4  
Old November 23rd 16, 06:11 PM posted to microsoft.public.excel.programming
GS[_6_]
external usenet poster
 
Posts: 695
Default Out of Memory

> I previously downloaded it. It installed without error.
> It just failed to add an entry to any of my VBIDE (Visual Basic
> Integrated Development Environment) menus. Very frustrating as I
> can't
> now find anything to do a similar job.


It should add a menuitem Tools>Clean Project... if you downloaded the
latest version (a DLL COMAddin). You must allow trust access to VBA
Projects.

If you have the older addin version you need to enable it to load on
startup in the Addins Manager dialog of the VBE IDE. I recommend
downloading the latest version since that's all Rob supports now!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #5  
Old November 24th 16, 01:03 AM
Tslebyng224 Tslebyng224 is offline
Banned
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 4
Default

Quote:
Originally Posted by Walter Briscoe View Post
I have just worked around a problem. It seems friendly to report my experience. I use Excel 2003 and most of my code is in PERSONAL.XLS. I had created a new sub, which is a renaming of another. I lost the plot and saved PERSONAL.XLS. When I opened Excel again, I got an &quot;Out of Memory&quot; dialog box. Throwing away a lot of redundant code did not help. I could run no code. I moved PERSONAL.XLS away from Application.StartupPath. I created an empty PERSONAL.XLS. (Save a dummy macro in Personal Macro Workbook.) Previously, I had copied Sub ExportAllComponents from somewhere. (Possibly &lt;https://www.experts-exchange.com/art...1457/Automate- Exporting-all-Components-in-an-Excel-Project.html&gt I used that code on my old PERSONAL.XLS. I imported the components, one at a time. I hit problems with the need to set Tools/References and to define types. Googling got me information to set references. When I had got a compilable file, my new PERSONAL.XLS was about 2MB. The old file was about 20MB. I have no notion what went wrong. -- Walter Briscoe
I loved as much as you will receive carried out right here. The sketch is attractive, your authored material stylish. nonetheless, you command get got an impatience over that you wish be delivering the following. unwell unquestionably come further formerly again as exactly the same nearly very often inside case you shield this increase.
  #6  
Old November 24th 16, 02:03 AM
Tslebyng224 Tslebyng224 is offline
Banned
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 4
Default

Quote:
Originally Posted by Walter Briscoe View Post
I have just worked around a problem. It seems friendly to report my experience. I use Excel 2003 and most of my code is in PERSONAL.XLS. I had created a new sub, which is a renaming of another. I lost the plot and saved PERSONAL.XLS. When I opened Excel again, I got an &quot;Out of Memory&quot; dialog box. Throwing away a lot of redundant code did not help. I could run no code. I moved PERSONAL.XLS away from Application.StartupPath. I created an empty PERSONAL.XLS. (Save a dummy macro in Personal Macro Workbook.) Previously, I had copied Sub ExportAllComponents from somewhere. (Possibly &lt;https://www.experts-exchange.com/art...1457/Automate- Exporting-all-Components-in-an-Excel-Project.html&gt I used that code on my old PERSONAL.XLS. I imported the components, one at a time. I hit problems with the need to set Tools/References and to define types. Googling got me information to set references. When I had got a compilable file, my new PERSONAL.XLS was about 2MB. The old file was about 20MB. I have no notion what went wrong. -- Walter Briscoe
Oh my goodness! Amazing article dude! Many thanks, However I am having troubles with your RSS. I don?t know the reason why I cannot subscribe to it. Is there anyone else getting the same RSS issues? Anyone who knows the solution will you kindly respond? Thanx!!
  #7  
Old November 24th 16, 08:08 AM
PhunuSEO PhunuSEO is offline
Junior Member
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 9
Default

Quote:
Originally Posted by Walter Briscoe View Post
I have just worked around a problem. It seems friendly to report my experience. I use Excel 2003 and most of my code is in PERSONAL.XLS. I had created a new sub, which is a renaming of another. I lost the plot and saved PERSONAL.XLS. When I opened Excel again, I got an &quot;Out of Memory&quot; dialog box. Throwing away a lot of redundant code did not help. I could run no code. I moved PERSONAL.XLS away from Application.StartupPath. I created an empty PERSONAL.XLS. (Save a dummy macro in Personal Macro Workbook.) Previously, I had copied Sub ExportAllComponents from somewhere. (Possibly &lt;https://www.experts-exchange.com/art...1457/Automate- Exporting-all-Components-in-an-Excel-Project.html&gt I used that code on my old PERSONAL.XLS. I imported the components, one at a time. I hit problems with the need to set Tools/References and to define types. Googling got me information to set references. When I had got a compilable file, my new PERSONAL.XLS was about 2MB. The old file was about 20MB. I have no notion what went wrong. -- Walter Briscoe
topic rất chuẩn. l*m mới để bay xa nhé
  #8  
Old November 24th 16, 12:51 PM
aloinam109 aloinam109 is offline
Banned
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 9
Default

Website batdongsanquangninh.vn l* website h*ng đầu về quảng cáo, mua bán bất động sản tại Quảng Ninh, ch*nh thức đươc th*nh l*p v*o năm 2012. Lĩnh vực hoạt động ch*nh của công ty l* quảng cáo, tư vấn, môi giới, mua bán, cho thuê bất động sản.

Trải qua nhiều năm hoạt động chúng tôi đã nỗ lực vượt qua mọi khó khăn để dần từng bước thay đổi được phương thức quảng cáo v* mua bán truyền thống của người dân th*nh phố giúp cho Người bán v* Người mua rễ d*ng thực hiện các giao dịch mua bán nh*, đất một cách minh bạch, nhanh chóng. Rút kinh nghiệm qua việc hoạt động nhiều năm và từ những ý kiến đóng góp của quý khách, trong thời gian tới chúng tôi sẽ nỗ lực hơn nưa nhằm phát triển Website có thêm những t*nh năng ưu việt, quảng bá rộng khắp hơn nữa giúp cho các giao dịch được tiến h*nh một cách nhanh chóng.

Ra đời xuất phát từ trải nghiệm thực tế của ch*nh người sáng l*p ra Công ty với mong muốn giúp cho cộng đồng có được thông tin minh bạch mang lại giá trị lợi *ch tốt nhất cho khách h*ng. Đây ch*nh l* cơ sở nền tảng để công ty xây dựng phương châm kinh doanh với mong muốn mang đến sự chuyên nghiệp, uy t*n, niềm tin cho khách h*ng.

Các dịch vụ ch*nh:

- Đăng tin quảng cáo mua bán nh* đất
- Đăng banner quảng cáo
- Đăng b*i PR quảng bá sản phẩm, dịch vụ bất động sản
- Tư vấn, mua bán bất động sản
- Môi giới bất động sản
- Nh* đất quảng ninh
- bất động sản hạ long
- Nh* đất quang ninh
- mua đất ha long
Mọi thông tin đóng góp, quý khách vui lòng liên hệ

Địa chỉ : Nguyễn Văn Cừ - Hạ Long - Quảng NinhĐiện thoại : 0984.690.188Email :
  #9  
Old November 25th 16, 05:20 PM posted to microsoft.public.excel.programming
Walter Briscoe
external usenet poster
 
Posts: 279
Default Out of Memory

In message > of Wed, 23 Nov 2016 13:11:19 in
microsoft.public.excel.programming, GS > writes
>> I previously downloaded it. It installed without error.
>> It just failed to add an entry to any of my VBIDE (Visual Basic
>> Integrated Development Environment) menus. Very frustrating as I
>>can't
>> now find anything to do a similar job.

>
>It should add a menuitem Tools>Clean Project... if you downloaded the
>latest version (a DLL COMAddin). You must allow trust access to VBA
>Projects.
>
>If you have the older addin version you need to enable it to load on
>startup in the Addins Manager dialog of the VBE IDE. I recommend
>downloading the latest version since that's all Rob supports now!
>


I have the latest version. I exchanged emails with Rob. Code Cleaner was
marked as a disabled item in Excel/Help/About Microsoft Office
Excel/Disabled Items...
Correcting that cured the problem.
--
Walter Briscoe
  #10  
Old November 25th 16, 09:49 PM posted to microsoft.public.excel.programming
GS[_6_]
external usenet poster
 
Posts: 695
Default Out of Memory

> In message > of Wed, 23 Nov 2016 13:11:19
> in microsoft.public.excel.programming, GS > writes
>>> I previously downloaded it. It installed without error.
>>> It just failed to add an entry to any of my VBIDE (Visual Basic
>>> Integrated Development Environment) menus. Very frustrating as I
>>> can't
>>> now find anything to do a similar job.

>>
>> It should add a menuitem Tools>Clean Project... if you downloaded
>> the latest version (a DLL COMAddin). You must allow trust access to
>> VBA Projects.
>>
>> If you have the older addin version you need to enable it to load on
>> startup in the Addins Manager dialog of the VBE IDE. I recommend
>> downloading the latest version since that's all Rob supports now!
>>

>
> I have the latest version. I exchanged emails with Rob. Code Cleaner
> was marked as a disabled item in Excel/Help/About Microsoft Office
> Excel/Disabled Items...
> Correcting that cured the problem.


That's great! Thanks for the feedback...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
XL 2007 - Out of Memory - memory leak/bug? PCLIVE Excel Discussion (Misc queries) 0 March 23rd 09 03:31 PM
(reposting) Memory problem: Out of Memory and cannot save WHA Excel Programming 0 November 30th 07 05:09 PM
Memory problem: Out of Memory and cannot save WHA Excel Programming 0 November 30th 07 03:52 AM
Not Enough Memory Adam Excel Discussion (Misc queries) 9 August 31st 05 12:35 PM
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc Angus Comber[_2_] Excel Programming 1 November 7th 03 01:18 PM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.