+ Reply to Thread
Results 1 to 2 of 2

Macro causes huge file size

  1. #1
    Registered User
    Join Date
    10-22-2008
    Location
    US
    Posts
    15

    Macro causes huge file size

    Hi:

    I have an excel wookbook (excel 2010) that has a small macro (15 lines of basic look and replace) attached to it. The file size is 25 megs, but if I remove the macro, the file size decreases to 6 megs... Is there a way of keeping the file size low and still have the macro attached to the file?

    Thanks for any help you can provide.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Macro causes huge file size

    Hi tdyl1969
    you could try the code cleaner add-in
    http://www.excelforum.com/excel-prog...to-macros.html
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1