Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 661
Default magic scissors

I took a file and i added some code to eliminate the "do you want to save
....before closing" message box. A pretty minor change.

Well adding this code made the file size go from 104K to 79K - it some how
choped off 1/5 of the file size. Does anyone know why this would happen?
nothing was removed from the file, and all that was added was a short line of
code.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default magic scissors

Was the file originally saved in a different version of Excel?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Paul" wrote in message
...
I took a file and i added some code to eliminate the "do you want to save
...before closing" message box. A pretty minor change.

Well adding this code made the file size go from 104K to 79K - it some how
choped off 1/5 of the file size. Does anyone know why this would happen?
nothing was removed from the file, and all that was added was a short line

of
code.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 661
Default magic scissors

nope, same version of excel. it was last saved about a month ago.

at first i was worried that i accidentally deleted something, but i've been
checking over it and everything seems to be as it should be. it scared me at
first because that's 20% of the file size, but now that i think about it,
it's a pretty small file to begin with, and 25K isn't really that much to
disapper.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IDE add-on VB Magic? peterv Excel Discussion (Misc queries) 1 March 10th 06 11:34 PM
Dates and VBA Magic! tip2tail Excel Programming 3 October 26th 05 08:32 AM
Magic Cells Jacob_F_Roecker Excel Discussion (Misc queries) 7 July 23rd 05 10:04 PM
Macro Magic Wand Gordon[_12_] Excel Programming 5 August 6th 04 04:34 PM
Magic Shrinking Listbox Patrick Molloy Excel Programming 1 July 22nd 03 12:00 PM


All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"