Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Huhe ecel file size
Hello,
I would appreciate any input on this matter. My file starts out being around 1meg just one sheet with lots of VBA code, when I insert a userform, the file size become 19MB. There are some picuture in the user orm, I tried them, just Still I get huge file sizes around 18M, not sure what is taking up the space because when I compress it it become arounf 400KB I put a comman button "main" in the worksheet . when I click on it, it takes a lot of time to load the userform. I don't know why? Thank You! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Huhe ecel file size
It sounds like the picture file that you imported is the problem. High
megapixel pictures take up a lot of space, and take time to load. Try compressing the picture separately then importing it into the userform. -- JNW "Bizarre" wrote: Hello, I would appreciate any input on this matter. My file starts out being around 1meg just one sheet with lots of VBA code, when I insert a userform, the file size become 19MB. There are some picuture in the user orm, I tried them, just Still I get huge file sizes around 18M, not sure what is taking up the space because when I compress it it become arounf 400KB I put a comman button "main" in the worksheet . when I click on it, it takes a lot of time to load the userform. I don't know why? Thank You! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Huhe ecel file size
I compressed the 3 pictures (8k each ) but it does not solve the problem.
Even I tried to remove oictures but the file is still 19 MB. I forgot to note before that there are at least 3 spreadsheet and 3 chartspace controls in the user form. Could that be the problem? "JNW" wrote: It sounds like the picture file that you imported is the problem. High megapixel pictures take up a lot of space, and take time to load. Try compressing the picture separately then importing it into the userform. -- JNW "Bizarre" wrote: Hello, I would appreciate any input on this matter. My file starts out being around 1meg just one sheet with lots of VBA code, when I insert a userform, the file size become 19MB. There are some picuture in the user orm, I tried them, just Still I get huge file sizes around 18M, not sure what is taking up the space because when I compress it it become arounf 400KB I put a comman button "main" in the worksheet . when I click on it, it takes a lot of time to load the userform. I don't know why? Thank You! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
ecel:create a file name from data in worksheet | Excel Worksheet Functions | |||
Ecel to PowerPoint | Excel Discussion (Misc queries) | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming |