ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Out of Memory (https://www.excelbanter.com/excel-programming/452785-out-memory.html)

Walter Briscoe
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

GS[_6_]
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

Walter Briscoe
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

GS[_6_]
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

Tslebyng224
Quote:
Originally Posted by Walter Briscoe (Post 1627181)
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.

Tslebyng224
Quote:
Originally Posted by Walter Briscoe (Post 1627181)
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!!

PhunuSEO
Quote:
Originally Posted by Walter Briscoe (Post 1627181)
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é

aloinam109
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 :

Walter Briscoe
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

GS[_6_]
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

Tvlebung396
Yeah bookmaking this wasn't a high risk decision outstanding post!

aloinam109
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
- ban nha quảng ninh
- nha dat hạ long
- ban đất quang ninh
- bất động sản 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 :

PhunuSEO
Không giống các bệnh lý khác về vùng đầu cổ, bệnh ung thư vòm họng thường rất khó phát hiện sớm. Cộng thêm tâm lý chủ quan của người bệnh, vì thế căn bệnh thường qua mắt được rất nhiều người, tiến triển một cách âm thầm, hầu như không biểu hiện triệu chứng gì đáng kể, chỉ đến khi giai đoạn cuối mới phát tác mạnh mẽ.

Mời các bạn xem video sau để hiểu rõ hơn về hai loại thần dược chống Ung thư vòm họng nhé

https://www.youtube.com/watch?v=wl6SyAlLTic


All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com