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

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

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 topic rất chuẩn. lÃ*m má»›i để bay xa  nhé




-- 
PhunuSEO

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