+ Reply to Thread
Results 1 to 5 of 5

File has become very heavy

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    48

    File has become very heavy

    i have created a macro, in which 6 variables are created using the fallowing code

    Please Login or Register  to view this content.

    This macro is run more than 100 times in a day. For the first few days the file was ok but now the file size has become 10mb, even though there is not much data in that, considering the amount of data in that the file size shud be no more than 1Mb. I think this is because every time the macro is run the 7 variables are created again and again so it is taking too much memory. Am i correct? If yes then wat is the code for disposing the variable?? if no then wat is the reason for the file being soo heavy??

    Thank yu

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: File has become very heavy

    The variables are not stored once the macro is finished so no, this is not the reason.

  3. #3
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: File has become very heavy

    "This macro is run more than 100 times in a day"
    What does the macro do? What is the macro intended to do?

  4. #4
    Registered User
    Join Date
    11-28-2012
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: File has become very heavy

    may be im exaggerating a bit by saying hundred but its around 60 times atleast. It creates bill everytime a customer purchases something, So the more the customers the more times it runs. Wat do i do about it??

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,891

    Re: File has become very heavy

    Quote Originally Posted by Suraj3825 View Post
    Wat do i do about it??
    Post the macro

+ 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