Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109663

Re: Out of Memory

Show all headers | View raw

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 "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 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

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

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

csiph-web