Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-15-2018, 08:10 PM
eduzs eduzs is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: May 2017
Posts: 98
eduzs is on a distinguished road
Default Why my Docm file does not shrink in size?

Just for curiosity,
I have a DOCM file that I removed a dozen unnecessary text boxes in a userform and one or two subs etc., but the file sizes change so little or not at all.
Even when I just open the file and save the sizes grew (only once) with no modification at all from 283kb to +- 300kb.


Exactly at this moment I deleted 3 lines of the code and the size increased from 306kb to 309kb.


Thanks
__________________
Backup your original file before doing any modification.
Reply With Quote
  #2  
Old 09-15-2018, 10:01 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 827
Guessed is on a distinguished road
Default

Is Revision Tracking turned on?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 09-16-2018, 12:47 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,249
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

The compressibility of a given document in the XML format depends on what the content is, not just the amount of it.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 09-16-2018, 04:13 AM
eduzs eduzs is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: May 2017
Posts: 98
eduzs is on a distinguished road
Default

Thanks!

Is Revision Tracking turned on? No

I exported all 3 userforms and 2 modules, then created a new .DOCM file.
Then I imported all these content to the new DOCM file.
The size at the 1st save decreased from 310kb to 74kb, after using the file, it's grows* to 104kb, but still 1/3 the size of the original file.
* The file just auto save each time it's opened (form queryclose event) a docvariable with len 4 "0000" to save some parameters.
After using a few times, the size now ranges from 79ks to 101kb all (It has now stabilized in 95kb)
I suppose, somehow, it keeps deleted data (especially from excluded controls forms modules, causing this size difference).
__________________
Backup your original file before doing any modification.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to animate a photo to start zoomed in and then shrink to normal size? Tabathavm PowerPoint 2 05-05-2018 01:26 PM
any way to shrink size of embedded fonts? rod2 PowerPoint 0 06-03-2016 07:08 AM
SaveAs docm file from template ptmuldoon Word VBA 7 03-09-2015 05:38 PM
How to convert docm to dotm without opening the file Moz Word 1 12-20-2012 04:23 PM
Possible to shrink .DOC file? uoficowboy Word 0 06-09-2010 10:13 AM


All times are GMT -7. The time now is 03:51 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft