Re: Excel File Size Issues

That is a crazy size. Do you have some big pictures or objects in your
workbook? I think the code itself is unlikely to take up that kind of space
unless there is really loads of it (like hundreds of forms/modules).

Jeff

"jwillert" <jwillert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AA59AB1B-1469-4711-81B3-3528D35EF2BA@xxxxxxxxxxxxxxxx
I am currently doing some excel programming and my current file has become
unreasonably large (120+ MB) and excel is slowing down and freezing at
times.
It should not be an issue with either my computer or memory, as they are
both sufficient. Is there any way to speed up macros or any tips on
cutting
down on unneccessary code?


.

Relevant Pages

  • Re: Error with closing the Excel file
    ... After a lot of testing in your workbook I found the problem ... Excel 2007 not like that. ... The only way to avoid this problem is to replace the pictures for Forms ot ActiveX buttons I think. ... if I have macros in my workbook, or if I just bring up the macro ...
    (microsoft.public.excel.misc)
  • RE: replace text string automatically in cell
    ... put a copy of the workbook with this code in it into any ... It will open each .xls file in the folder that it is placed into in turn, ... pictures or linked pictures, and then do a massive Edit|Replace All action on ... Dim WS As Worksheet ...
    (microsoft.public.excel.misc)
  • Re: email excel file w/ inserted objects
    ... "Dave Peterson" wrote: ... if your pictures are large files, then this doesn't sound practical to me. ... Then your hyperlinks would point to the correct location. ... workbook is opened procedure). ...
    (microsoft.public.excel.misc)
  • Re: email excel file w/ inserted objects
    ... if your pictures are large files, then this doesn't sound practical to me. ... They HAVE to use the the folder name that you tell ... Then your hyperlinks would point to the correct location. ... workbook is opened procedure). ...
    (microsoft.public.excel.misc)
  • RE: Deleting Pictures to reduce workbook size
    ... Dim w As Worksheet ... If pCount> 0 Then ... This little sub will remove all pictures on all worksheets in a workbook: ...
    (microsoft.public.excel.misc)