Groups > microsoft.public.excel.programming > #109622 > unrolled thread

Out of Memory

Started by	Walter Briscoe <wbriscoe@nospam.demon.co.uk>
First post	2016-11-20 23:08 +0000
Last post	2016-11-27 03:00 +0000
Articles	12 — 6 participants

Back to article view | Back to microsoft.public.excel.programming

  Out of Memory Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-11-20 23:08 +0000
    Re: Out of Memory GS <gs@v.invalid> - 2016-11-21 15:06 -0500
      Re: Out of Memory Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-11-23 12:56 +0000
        Re: Out of Memory GS <gs@v.invalid> - 2016-11-23 13:11 -0500
          Re: Out of Memory Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-11-25 17:20 +0000
            Re: Out of Memory GS <gs@v.invalid> - 2016-11-25 16:49 -0500
    Re: Out of Memory Tslebyng224 <Txlebjng923@gmail.com> - 2016-11-24 01:03 +0000
    Re: Out of Memory Tslebyng224 <Txlebjng923@gmail.com> - 2016-11-24 02:03 +0000
    Re: Out of Memory PhunuSEO <PhunuSEO@gmail.com> - 2016-11-24 08:08 +0000
    Re: Out of Memory aloinam109 <aloinam109@gmail.com> - 2016-11-24 12:51 +0000
    Re: Out of Memory Tvlebung396 <Tblebsng105@gmail.com> - 2016-11-26 07:02 +0000
    Re: Out of Memory PhunuSEO <PhunuSEO@gmail.com> - 2016-11-27 03:00 +0000

#109622 — Out of Memory

From	Walter Briscoe <wbriscoe@nospam.demon.co.uk>
Date	2016-11-20 23:08 +0000
Subject	Out of Memory
Message-ID	<sBLJqUCnziMYFw$C@freenetname.co.uk>

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/articles/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

[toc] | [next] | [standalone]

#109629

From	GS <gs@v.invalid>
Date	2016-11-21 15:06 -0500
Message-ID	<o0vk3u$vce$1@dont-email.me>
In reply to	#109622

> 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/articles/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

[toc] | [prev] | [next] | [standalone]

#109654

From	Walter Briscoe <wbriscoe@nospam.demon.co.uk>
Date	2016-11-23 12:56 +0000
Message-ID	<6rpsAcEqHZNYFwG3@freenetname.co.uk>
In reply to	#109629

In message <o0vk3u$vce$1@dont-email.me> of Mon, 21 Nov 2016 15:06:56 in
microsoft.public.excel.programming, GS <gs@v.invalid> 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/articles/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_VBADecompiler.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

[toc] | [prev] | [next] | [standalone]

#109657

From	GS <gs@v.invalid>
Date	2016-11-23 13:11 -0500
Message-ID	<o14m1t$em1$1@dont-email.me>
In reply to	#109654

> 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

[toc] | [prev] | [next] | [standalone]

#109681

From	Walter Briscoe <wbriscoe@nospam.demon.co.uk>
Date	2016-11-25 17:20 +0000
Message-ID	<zE6e7IApLHOYFw91@freenetname.co.uk>
In reply to	#109657

In message <o14m1t$em1$1@dont-email.me> of Wed, 23 Nov 2016 13:11:19 in
microsoft.public.excel.programming, GS <gs@v.invalid> 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

[toc] | [prev] | [next] | [standalone]

#109685

From	GS <gs@v.invalid>
Date	2016-11-25 16:49 -0500
Message-ID	<o1abj5$k8c$1@dont-email.me>
In reply to	#109681

> In message <o14m1t$em1$1@dont-email.me> of Wed, 23 Nov 2016 13:11:19 
> in microsoft.public.excel.programming, GS <gs@v.invalid> 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

[toc] | [prev] | [next] | [standalone]

#109663

From	Tslebyng224 <Txlebjng923@gmail.com>
Date	2016-11-24 01:03 +0000
Message-ID	<Tslebyng224.127bfc88@excelbanter.com>
In reply to	#109622

Walter Briscoe;1627181 Wrote: 
> 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/articles/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

[toc] | [prev] | [next] | [standalone]

#109664

From	Tslebyng224 <Txlebjng923@gmail.com>
Date	2016-11-24 02:03 +0000
Message-ID	<Tslebyng224.127c0a98@excelbanter.com>
In reply to	#109622

Walter Briscoe;1627181 Wrote: 
> 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/articles/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!!




-- 
Tslebyng224

[toc] | [prev] | [next] | [standalone]

#109670

From	PhunuSEO <PhunuSEO@gmail.com>
Date	2016-11-24 08:08 +0000
Message-ID	<PhunuSEO.127c5ef8@excelbanter.com>
In reply to	#109622

Walter Briscoe;1627181 Wrote: 
> 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/articles/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Ã©




-- 
PhunuSEO

[toc] | [prev] | [next] | [standalone]

#109672

From	aloinam109 <aloinam109@gmail.com>
Date	2016-11-24 12:51 +0000
Message-ID	<aloinam109.127ca548@excelbanter.com>
In reply to	#109622

*     [image:
http://batdongsanquangninh.vn/images/banners/logo.png]*
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
hoaÌ£t Ä‘Ã´Ì£ng nhiÃªÌ€u nÄƒm vaÌ€ 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' (http://batdongsanquangninh.vn)
- 'báº¥t Ä‘á»™ng sáº£n háº¡ long' (http://batdongsanquangninh.vn)
- 'NhÃ* Ä‘áº¥t quang ninh' (http://batdongsanquangninh.vn)
- 'mua Ä‘áº¥t ha long' (http://batdongsanquangninh.vn)
*::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.188**Email :
batdongsanquangninh.vn@gmail.com*




-- 
aloinam109

[toc] | [prev] | [next] | [standalone]

#109691

From	Tvlebung396 <Tblebsng105@gmail.com>
Date	2016-11-26 07:02 +0000
Message-ID	<Tvlebung396.127ef3e8@excelbanter.com>
In reply to	#109622

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




-- 
Tvlebung396

[toc] | [prev] | [next] | [standalone]

#109699

From	PhunuSEO <PhunuSEO@gmail.com>
Date	2016-11-27 03:00 +0000
Message-ID	<PhunuSEO.12800d28@excelbanter.com>
In reply to	#109622

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




-- 
PhunuSEO

[toc] | [prev] | [standalone]

csiph-web

Out of Memory

Contents

#109622 — Out of Memory

#109629

#109654

#109657

#109681

#109685

#109663

#109664

#109670

#109672

#109691

#109699