+ Reply to Thread
Results 1 to 4 of 4

Reduce File Size

  1. #1
    Registered User
    Join Date
    11-11-2007
    Posts
    10

    Reduce File Size

    I have a workbook that is over 55meg. It has an above average number of worksheets and modules.

    The file has very little formatting or formulas. Functionality is handled by VBA script in modules. There is a total of about 100 modules. So it is going to be difficult to copy them to another file and paste them back.

    I have gone to each worksheet to delete unused rows and columns and deleted formatting where it is not used.

    I tried running an "excel diet" function i found on the web, but it would not run.

    The size of this file is making it difficult for my users to load, run and save.

    Any suggestions will be greatly appreciated.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    100 modules......why?
    How many sheets as this may also impact. see link re memory issues

    http://www.decisionmodels.com/index.htm

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    11-11-2007
    Posts
    10

    response re reduce file size

    I used a separate module for each sub so that i can document the location and purpose for each sub. Is there a better way?

    And there are are about 40 worksheets in the file.

    Thanks for the help.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Quote Originally Posted by tbaker897 View Post
    I used a separate module for each sub so that i can document the location and purpose for each sub. Is there a better way?

    And there are are about 40 worksheets in the file.

    Thanks for the help.
    I can't see how that makes it easier. I usually categorise procedures & place eacg category into a separate module.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excle data file and macro publishing problem
    By sujata_ghosh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2008, 04:19 AM
  2. Shared Workboook - File Size issue
    By bullwinkle55423 in forum Excel General
    Replies: 0
    Last Post: 02-04-2008, 12:02 PM
  3. file size doubling
    By khalid79m in forum Excel General
    Replies: 2
    Last Post: 11-22-2007, 09:11 AM
  4. Hyperlink to a file regardless of file type
    By djmarak in forum Excel General
    Replies: 2
    Last Post: 09-21-2007, 12:24 PM
  5. File size after runnign macro
    By r_dearn in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-25-2006, 04:44 AM

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