Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 21st 16, 12:08 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
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

  #2   Report Post  
Old November 21st 16, 09:06 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 763
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   Report Post  
Old November 23rd 16, 01:56 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
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   Report Post  
Old November 23rd 16, 07:11 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 763
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 ToolsClean 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   Report Post  
Old November 24th 16, 02:03 AM
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   Report Post  
Old November 24th 16, 03:03 AM
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   Report Post  
Old November 24th 16, 09:08 AM
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   Report Post  
Old November 24th 16, 01:51 PM
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   Report Post  
Old November 25th 16, 06:20 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
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 ToolsClean 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   Report Post  
Old November 25th 16, 10:49 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 763
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 ToolsClean 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 04:31 PM
(reposting) Memory problem: Out of Memory and cannot save WHA Excel Programming 0 November 30th 07 06:09 PM
Memory problem: Out of Memory and cannot save WHA Excel Programming 0 November 30th 07 04: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 02:18 PM


All times are GMT +1. The time now is 06:56 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017